Location
Pune | India
Job description
Job Description:
A database administrator (DBA) in digital web services is responsible for designing, implementing, and maintaining the databases. This position requires expertise in database management systems, knowledge of database security, and experience in database performance tuning.
The DBA must work closely with developers, network administrators, and other IT staff to ensure that the databases are optimized for performance, highly available, and secure.
Candidates must have the following skills:
- Expertise in MySQL and Oracle database systems MySQL 8.0 experience a plus MS SQL Server experience a plus
- Expertise in Structured Query Language (SQL)
- Expertise in database design, ERDs, schema creation
- Expertise in creating stored procedures, functions, views
- Expertise in managing databases on AWS RDS, Google Cloud SQL, or Azure Database services
Position Responsibilities and Essential Duties: (Other duties may be assigned)
- Ability to work efficiently with MySQL and Oracle databases any experience with SQL Server a plus
- Ensure data integrity and system performance for all of our databases
- Create and maintain the database schemas based on business and project requirements
- Understand the intended use of the database structures & help educate development team members on them
- Write efficient complex queries assist developers to do the same
- Configure and maintain replication, log shipping, etc.
- Create upgrade scripts to move changes from development to production
- Support database management and provide help for upgrade and migration of databases to new releases
- Maintain database documentation
- Advise and guide systems development team members on database/file design, performance monitoring and application/maintenance design and tuning
- Troubleshoot the incidents and problems reported on database systems
- Work with IT and Client Solution team members to ensure the database integrity, high availability and security
- Help provide the root cause analysis on the major incidents/problems
Education/Experience:
- 8+ years in DB Administration with MySQL and Oracle
- Bachelor's degree in computer science, information science, or a related field
- Expertise in MySQL and Oracle database systems MySQL 8.0 experience a plus MS SQL Server experience a plus
- Should have experience with at least two of the following database platforms: SQL Server, MongoDB, MySQL, or PostgreSQL
- Expertise in Structured Query Language (SQL)
- Expertise in database design, ERDs, schema creation
- Expertise in creating stored procedures, functions, views
- Familiarity with database automation and scripting using languages like Python, PHP, PowerShell, or Bash
- Detail-oriented, strong analytical and problem-solving skills
- Excellent communication and team-building skills and can work independently
- Ability to interact with business users and executive management and translate business requirements into technical implementations
- Ability to collaborate with cross-functional teams, including developers and system administrators.
- Hands-on experience with database migration, especially between on-premises and cloud environments.
- Knowledge of database security practices and implementation of access controls.
- Familiarity with infrastructure as code tools (e.g., AWS CloudFormation, Google Cloud Deployment Manager, Azure Resource Manager).
- Skill in database performance tuning and troubleshooting using monitoring tools.
- Experience with database backup and recovery strategies in a cloud environment.
- Understanding of High Availability (HA) and Disaster Recovery (DR) configurations for cloud databases.
- Certifications such as Oracle Certified Professional (OCP), Microsoft Certified Database Administrator (MCDBA), a plus
- Certifications in relevant cloud platforms (AWS, Google Cloud, Azure) and database technologies a plus
© 2024 Affinity Express, Inc. All Rights Reserved.
Job tags
Salary
