SQL Developer Database Administrator
Job Location:
Monthly Salary:
Experience Required:
Posted on:
Vacancies:
Job Summary
Administer maintain and support MS SQL Server databases across development and production environments
Perform backups restores and manage recovery models
Conduct performance tuning and optimization (PTO) using native monitoring tools
Implement and manage high availability (HA) and disaster recovery (DR) solutions
Configure and maintain database servers and processes ensuring system health availability and security.
Approve developers change requests for database objects such as tables procedures indices constraints triggers and views
Assist developers in performance tuning and query optimization
Independently troubleshoot and resolve database issues in real time
Automate routine processes monitor database jobs and track/document changes
Collaborate with teams to manage database transitions across multiple product lifecycle Stages.
Requirements
Minimum 3 years of experience as an MS SQL Server DBA
Strong knowledge of SQL queries stored procedures indexes and query plans
Proficiency in backup/restore strategies and recovery models
Solid understanding of HA/DR setups and replication techniques
Familiarity with performance monitoring tools and techniques
Ability to work independently and resolve issues quickly and effectively
Excellent communication and collaboration skills
Required Skills:
Key Responsibilities Develop maintain and optimize SQL queries stored procedures views functions and triggers. Design and manage database structures to ensure data integrity security scalability and performance. Write complex SQL queries for data extraction transformation validation and reporting purposes. Create efficient reports dashboards and datasets to support business intelligence and operational requirements. Perform database performance tuning query optimization execution plan analysis and indexing strategies. Develop and optimize joins subqueries CTEs window functions and aggregate queries for large datasets. Support data migration integration ETL and data transformation activities across multiple systems. Collaborate with software developers business analysts and stakeholders to understand and implement data requirements. Troubleshoot and resolve database-related issues including query performance bottlenecks and data inconsistencies. Monitor database health performance metrics and system availability to ensure reliable operations. Create maintain and update technical documentation for database objects processes and data flows. Ensure compliance with data governance security standards backup and recovery procedures. Validate data accuracy and perform data quality checks using SQL scripts and automated processes. Assist in database deployment release management and production support activities.
Required Education:
QualificationsBachelors degree in Computer Science Information Technology Engineering or a related field.23 years of experience in SQL Development Database Administration or related understanding of relational database concepts and data working with enterprise-scale databases and reporting RequiredStrong proficiency in SQL with PostgreSQL MySQL Microsoft SQL Server or similar RDBMS.
