Job Title: Expert Database Administrator (DBA)
Job Summary:
We are seeking an Expert Database Administrator (DBA) to architect, manage, and optimize mission-critical databases for enterprise applications. The ideal candidate should have extensive experience in relational and cloud-based database administration, high-availability architectures, query performance tuning, and security compliance. This role involves leading database strategy, driving cloud migrations, optimizing large-scale database systems, and mentoring DBA teams to ensure data integrity, security, and scalability.
Key Responsibilities:
- Design and manage enterprise-grade database architectures, ensuring high availability (HA), scalability, and security
- Optimize complex SQL queries, indexing strategies, and execution plans for maximum performance
- Architect and implement clustering, replication, and failover strategies for database reliability
- Develop and enforce database security policies, including encryption, authentication, access control, and compliance with GDPR, HIPAA, PCI-DSS
- Lead cloud database migrations and hybrid database deployments (AWS RDS, Google Cloud SQL, Azure SQL, Snowflake)
- Manage multi-terabyte databases, high-transaction workloads, and distributed data processing
- Develop automation frameworks for backup, disaster recovery, and performance monitoring
- Collaborate with software engineers, DevOps, and data teams to optimize database interactions with applications
- Implement database infrastructure as code (IaC) using Terraform, Ansible, or Kubernetes
- Troubleshoot and resolve complex database performance issues, deadlocks, and bottlenecks
- Oversee ETL processes, data pipelines, and big data integrations
- Mentor DBA teams and enforce best practices in database security, performance, and automation
- Stay ahead of emerging database technologies, AI-driven analytics, and distributed database solutions
Skills and Knowledge Required:
- Expert-level proficiency in SQL, PL/SQL, T-SQL, and query optimization techniques
- Extensive experience in database administration for MySQL, PostgreSQL, Microsoft SQL Server, and Oracle
- Deep knowledge of cloud-based database solutions (AWS RDS, Aurora, Google Cloud SQL, Azure SQL, Snowflake, BigQuery)
- Strong expertise in database performance tuning, partitioning, indexing, and caching strategies
- Experience managing high-availability architectures, including clustering, failover, and replication
- Proficiency in scripting for database automation (Python, Bash, PowerShell)
- Knowledge of big data and distributed database technologies (Hadoop, Spark, Kafka, Flink)
- Hands-on experience with database monitoring tools (SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana)
- Strong understanding of database security, encryption techniques, and regulatory compliance
- Experience with DevOps practices and automation tools (Terraform, Kubernetes, Ansible, Jenkins, Docker)
Educational Qualifications:
- Bachelor’s, Master’s, or PhD in Computer Science, Data Science, Information Technology, or a related field
- Advanced certifications in SQL Server, Oracle DBA, AWS Certified Database – Specialty, Google Professional Data Engineer, Snowflake Certified Data Engineer are preferred
Experience:
- 10+ years of experience in database administration, high-performance optimization, and cloud database architecture
- Proven track record of leading enterprise-level database infrastructure projects and managing mission-critical data
- Experience handling multi-terabyte databases, real-time data processing, and AI-driven database analytics
Key Focus Areas:
- Enterprise-Scale Database Architecture & Optimization
- Cloud & Distributed Database Solutions
- Security, Compliance & Governance in Database Management
- AI/ML & Big Data Integration in Database Systems
- Leadership & Technical Mentorship for DBA Teams
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, Cassandra
- Query Languages: SQL, PL/SQL, T-SQL
- ETL & Data Pipeline Tools: Apache NiFi, Talend, Informatica, Airflow
- Cloud Databases: AWS RDS, Aurora, Google Cloud SQL, Azure SQL, Snowflake, BigQuery
- Big Data & Streaming Technologies: Hadoop, Spark, Kafka, Flink, Databricks
- DevOps & Automation: Terraform, Kubernetes, Docker, Jenkins, Ansible
- Monitoring & Performance Tools: SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana
Other Requirements:
- Strategic leadership and decision-making abilities for enterprise database management
- Strong ability to design and implement fault-tolerant, high-performance database solutions
- Excellent communication skills for technical presentations, stakeholder engagement, and knowledge transfer
- Passion for innovation in AI-driven database automation, predictive analytics, and cloud-native solutions