DBA SQL

Company Overview

Not specified

Job Summary

We are seeking a skilled and proactive Database Administrator (DBA) with strong SQL development expertise to manage, optimize, and support our database systems. The ideal candidate will have hands-on experience with cloud-based and on-premises database platforms, with a strong emphasis on AWS RDS, PostgreSQL, Redshift, and SQL Server. A background in developing and optimizing complex SQL queries, stored procedures, and data workflows is essential.

Responsibilities

• Design, implement, and maintain high-performance, scalable, and secure database systems on AWS RDS, PostgreSQL, Redshift, and SQL Server.
• Develop, review, and optimize complex SQL queries, views, stored procedures, triggers, and functions.
• Monitor database performance, implement tuning improvements, and ensure high availability and disaster recovery strategies.
• Collaborate with development and DevOps teams to support application requirements, schema changes, and release cycles.
• Perform database migrations, upgrades, and patch management.
• Create and maintain documentation related to database architecture, procedures, and best practices.
• Implement and maintain data security measures and access controls.
• Support ETL processes and troubleshoot data pipeline issues as needed.

Qualifications

• Mandatory Skills & Experience:
  • Strong hands-on experience with:
    • AWS RDS
    • PostgreSQL
    • Amazon Redshift
    • Microsoft SQL Server
  • Proficiency in SQL development, including performance tuning and query optimization.
  • Experience with backup strategies, replication, monitoring, and high-availability database configurations.
  • Solid understanding of database design principles and best practices.
  • Knowledge of SSIS, SSRS & SSAS development and its management.
  • Knowledge of database partitioning, compression, online performance monitoring/tuning.
  • Experience in the database release management process and script review.
  • Knowledge of Database mirroring, Always On Availability Groups (AAG), and Disaster Recovery procedures.
  • Knowledge in database monitoring and different monitoring tools.
  • Knowledge in data modeling, database optimization, and relational database schemas.
  • Knowledge in writing complex SQL queries and debugging through someone else’s code.
  • Experience in managing internal and external MS SQL database security.
  • Knowledge in Database Policies, Certificates, Database Mail, Resource Management.
  • Knowledge in SQL Server internals (Memory usage, DMVs, Threads, wait stats, Query Store, SQL Profiler).
  • Knowledge of Cluster Server management and failovers.
  • Knowledge of data modeling (SSARS), Reporting Services (SSRS, Tableau, PowerBI, Athena).

Preferred Skills

• Exposure to MySQL and Oracle databases.
• Familiarity with Azure Database Services (e.g., Azure SQL, Azure Database for PostgreSQL).
• Knowledge of scripting languages (e.g., Python, Bash) for automation is a plus.
• Experience working in Agile/Scrum environments.
• Knowledge of Java, PowerShell, or Python is preferred.

Experience

• 8+ years of experience in database management and development.

Environment

• This position is remote with working hours from 2 PM to 11 PM.

Salary

• Estimated salary: 1.2 LPM (Lakhs Per Month).

Growth Opportunities

Not specified

Benefits

Not specified