Database Administrator (DBA) (The Data Guardian)

Introduction: Are you a data expert with a passion for managing, optimizing, and safeguarding vast amounts of information? Do you thrive on ensuring that databases run efficiently, securely, and can handle the demands of modern applications? If you’re driven by creating scalable database architectures and ensuring data integrity, then our client has the perfect opportunity for you. We’re looking for a Database Administrator (DBA) (aka The Data Guardian) to manage our databases, optimize performance, and safeguard critical data assets. As a Database Administrator at our client , you’ll be responsible for maintaining the health, security, and performance of our databases, ensuring data is stored efficiently and accessed securely. You’ll work closely with development and operations teams to design, implement, and manage database systems that support high-performance applications. Key Responsibilities: Database Management and Optimization: Manage, monitor, and maintain the health of production and development databases (e.g., MySQL, PostgreSQL, MongoDB). Ensure databases are optimized for performance, scalability, and reliability. Backup and Recovery: Implement robust backup and recovery strategies to ensure that data is recoverable in the event of failures or disasters. Plan and execute regular backup operations, test recovery procedures, and create failover systems. Security and Access Management: Ensure database security by implementing strong access controls, encryption, and compliance measures. Safeguard sensitive data from unauthorized access and adhere to regulatory requirements like GDPR or HIPAA. Performance Tuning and Query Optimization: Analyze and optimize database performance by monitoring query execution, identifying bottlenecks, and making adjustments to improve response times. Collaborate with developers to optimize SQL queries and database schemas. Database Design and Architecture: Design, implement, and maintain database architectures that are scalable, secure, and aligned with business needs. Create efficient database models, work on normalization, and manage data indexing strategies. Monitoring and Troubleshooting: Set up and maintain database monitoring tools to detect performance issues, slow queries, and capacity bottlenecks. Troubleshoot issues proactively to ensure minimal downtime and maximum availability. Collaboration with Development Teams: Work closely with software engineers and DevOps teams to ensure database solutions align with application requirements. Support database migrations, schema updates, and ensure smooth integration with application deployments. Required Skills: Database Management Expertise: Strong experience with relational (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Redis). In-depth knowledge of database administration, backup, recovery, and performance tuning. Performance Optimization: Expertise in query optimization, indexing, and database performance tuning to ensure efficient and fast data retrieval. Ability to diagnose and fix slow-running queries and performance bottlenecks. Security and Compliance: Solid understanding of database security best practices, including access controls, encryption, and regulatory compliance (e.g., GDPR, HIPAA). Ensure that data is protected and handled with the highest levels of security. Scripting and Automation: Proficiency in scripting languages such as Python or Bash for automating routine database tasks, such as backups, monitoring, and updates. Familiarity with Infrastructure as Code (IaC) is a plus. Collaboration and Communication: Strong collaboration skills, with the ability to work closely with developers, DevOps, and IT teams to ensure that database solutions meet business and application requirements. Educational Requirements: Bachelor’s degree in Computer Science, Information Technology, or a related field. Equivalent experience in database administration is also valued. Certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator, or AWS Certified Database Specialty are a plus. Experience Requirements: 3 years of experience in database administration, with a proven track record of managing and optimizing databases in production environments. Experience with high-availability architectures, replication strategies, and disaster recovery planning for databases. Hands-on experience in cloud-based database services (e.g., AWS RDS, Google Cloud SQL, Azure SQL Database) is highly desirable. J-18808-Ljbffr