SQL DBA

# 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