Database Developer

  • Chennai
  • Straive

Role Overview:

The SQL Database Developer is responsible for managing and maintaining our Microsoft SQL Server databases. They play a critical role in ensuring data availability, security, and optimal performance. As a DBA, the requirement is to collaborate with developers, system administrators, and other stakeholders to design, implement, and maintain robust database solutions.

Proven work experience as a Database developer.

  • In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring).
  • Knowledge of software development and user interfaces for online applications.
  • Hands-on experience with SQL.
  • Familiarity with working with JavaScript, HTML, and Net Framework.
  • Excellent analytical and organizational skills.
  • Understanding the needs of front-end users and having a problem-solving mindset.
  • Excellent verbal and written communication skills.
  • Experience with data conversion and server migrations.
  • Ability to work in database optimization and performance optimization
  • Ability to do review or troubleshooting of database objects created by the development team, and provide/incorporate
  • recommendations for optimal performance of the system; identify and remove any development/implementation
  • risks
  • Proficiency in OLTP and OLAP/DSS database administration.
  • Familiarity with replication, clustering, and high availability options for SQL Server.
  • Desire to work from office is preferable

Key Responsibilities:

 Database Installation and Configuration:

o Install, configure, and upgrade Microsoft SQL Server instances.

o Set up and manage Always On availability groups and failover clustering for high availability.

 Performance Tuning and Optimization:

o Monitor and analyze database performance using tools like SQL Profiler and Performance Monitor.

o Optimize queries, indexes, and database structures to enhance overall system performance.

 Backup and Recovery:

o Implement and maintain database backup and recovery strategies.

o Ensure data integrity and minimize downtime during disaster scenarios.

 Security and Access Control:

o Provision user access to databases, following security best practices.

o Enforce data security by managing permissions, roles, and authentication mechanisms.

o Work along with Management for any audit related work and assist them with required information from

databases.

 Documentation and Reporting:

o Maintain detailed documentation of the SQL Server environment.

o Generate regular reports on database health, performance, and security.

 Data Integration and Reporting Services:

o Develop and maintain data integration processes using SQL Server Integration Services (SSIS).

o Create and manage reports using SQL Server Reporting Services (SSRS).

 Custom Database Objects:

o Design and develop custom database objects including but not limited to DB Schema, T-SQL scripts, stored

procedures, tables, views, and functions.

 Analytical Environment Management:

o Install, upgrade, configure, and fine-tune SQL Server 2008R2 analytical environments.

o Address relational and storage engine issues effectively.