Senior Database Administrator
Location
India
Posted
46 days ago
Salary
0
Seniority
Senior
No structured requirement data.
Job Description
Senior Database Administrator
Etech
Role Description - Database Operations and Reliability: - Design, implement, and manage robust High Availability (HA) and Disaster Recovery (DR) solutions (e.g., Replication, Always On Failover Clusters, Log Shipping) to ensure minimal downtime and data loss. - Have experience for and responsible for migrations of database servers including Mysql 5+ to newer, MariaDB 10+ to newer, MSSQL SQL Server 2016+ to newer versions while maintaining continuity for stored procedures, ETLS, applications, and role-based access for both Microsoft and non-Microsoft identities. - Participate and assist with implementation of policies for role-based access as well as transition plans for changes in access methodologies. - Proactively monitor database performance, identify bottlenecks, and execute expert-level query, index, and server-level tuning to optimize application responsiveness and resource utilization. - Implement and maintain comprehensive monitoring and alerting systems to proactively detect and resolve performance degradation, capacity issues, and system failures. - Plan, test, and execute regular database patching, version upgrades, and maintenance tasks (backups, integrity checks) during scheduled maintenance windows, including documentation, standardization, and audits. - Technical Expertise and Environment: - Serve as a subject matter expert for SQL Server and MySQL database environments, with familiarity managing MongoDB clusters. - Manage, deploy, and administer databases on cloud platforms, specifically utilizing services within AWS (e.g., RDS, EC2-hosted instances) and Azure (e.g., Azure SQL Database, VMs). - Implement and enforce security best practices, including user access management, encryption, auditing, and compliance with industry standards. - Manage database storage needs, plan for capacity scaling, and optimize resource allocation in the cloud to control costs. - Collaboration and Automation: - Partner closely with Software Engineering, DevOps, Infrastructure, and Security teams to provide database design input, troubleshoot application-related database issues, and integrate security policies. - Develop and maintain scripts (PowerShell, Python, or Shell) to automate routine operational tasks, reporting, and deployment processes. - Work with Infrastructure-as-Code (IaC) tools (e.g., Terraform, Ansible) to deploy and configure database infrastructure in an automated, repeatable manner. Qualifications - 5+ years of hands-on experience as an Operational or Production DBA. - Deep knowledge of SQL Server and MySQL architecture, internals, and advanced features (HA/DR, replication, security). Being strong in both is required. - Proven experience administering databases hosted on either AWS or Azure (experience with both is highly preferred). - Demonstrated commitment to participating in a 24/7 on-call rotation and responding to critical incidents outside of regular business hours. - Expert proficiency in T-SQL and/or PL/SQL and strong scripting capabilities (PowerShell, Python, or Bash). - Excellent problem-solving, analytical, and communication skills to clearly articulate technical issues to both technical and non-technical stakeholders. Requirements - Experience managing databases via Infrastructure-as-Code (IaC) tools like Terraform or Ansible. - Familiarity with NoSQL databases, specifically operational experience with MongoDB. - Relevant industry certifications (e.g., AWS Certified Database - Specialty, Microsoft Certified: Azure Database Administrator Associate). - Experience in optimizing database deployments for microservices architectures. Benefits - Night Shift allowance as per process - Health Insurance - Tuition Reimbursement - Work Life Balance Initiatives - Rewards & Recognition - Internal movement through IJP
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Senior Database Administrator – Software
Truelogic SoftwarePremium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.
Senior Database Administrator – Software
Truelogic SoftwarePremium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.
Senior Database Administrator – Software
Truelogic SoftwarePremium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.
Database Administrator – DBA
FP Markets (First Prudential Markets)Multi-regulated Broker | 40+ Industry Awards | Established in 2005 | 24/7 Customer Support |
• Administer production databases on AWS RDS — MySQL, PostgreSQL, MS SQL Server • Design and maintain HA / DR architectures: replication, Multi-AZ, read replicas, failover, backups • Tune performance — query optimization, indexing, execution plans, parameter groups • Capacity planning, sizing, and cost optimization across the database fleet • Manage schema changes and migrations safely in production • Monitor database health with Prometheus / Grafana / CloudWatch; tune alerting • Lead incident response for database outages, performance issues, and data integrity events • Implement and enforce security controls — encryption, access management, auditing, secrets rotation • Partner with developers on data modeling, query reviews, and access patterns • Automate routine work — backups, patching, provisioning — using IaC • Document standards, runbooks, and recovery procedures • Participate in on-call rotation
