Urgent Search Sr Specialist Database Administration

Job Description

Job Description:

Overall Purpose:

We are seeking a knowledgeable MySQL Database Administrator (DBA) responsible for managing and supporting MySQL database environments that underpin critical business applications. This role involves database design, configuration, maintenance, performance tuning, and ensuring reliability and security of MySQL databases across diverse operational environments. Knowledge of other database platforms like Oracle and cloud technologies such as Azure is considered a strong plus and will enhance your ability to contribute effectively.

Key Roles and Responsibilities:

- Manage MySQL database configuration, installation, upgrades, patches, and related software components.
- Ensure database reliability, recoverability, availability, and performance for mission-critical applications.
- Perform operational support activities including backup and recovery, disaster recovery planning, and data replication.
- Monitor database growth, disk space utilization, and proactively resolve database issues.
- Conduct SQL query tuning, schema design, and object management to optimize database performance.
- Automate routine database maintenance tasks and support deployment of database code across production and non-production environments.
- Maintain database security by applying necessary patches and managing user access controls.
- Collaborate with application teams to provide database consultation, including design guidance and performance optimization.
- Develop and maintain comprehensive database documentation including configuration files, operational procedures, and troubleshooting guides.
- Participate in project activities involving physical design, installation, and migration of database environments.
- Serve as a subject matter expert on MySQL features, best practices, and emerging technologies.
- Engage with database vendor support and manage vendor relationships when necessary.

Additional Responsibilities:

- Design and implement database tables based on application requirements.
- Support development teams by delivering stored procedures, SQL queries, and automated reports.
- Deploy database code and ensure smooth transitions between environments.
- Deliver and manage database security patches to maintain compliance and protect data integrity.
- Provide ongoing database maintenance and health checks to ensure optimal performance.

Key Competencies and Skills:

- Strong hands-on experience with MySQL database administration, including versions 5.x and above.
- Solid understanding of database backup, recovery, replication, and disaster recovery strategies.
- Expertise in SQL query tuning and schema design for performance optimization.
- Familiarity with Linux/Unix operating systems and shell scripting for automation will be an added advantage.
- Knowledge of other database platforms such as Oracle is a significant plus.
- Experience with cloud platforms, especially Azure, is highly desirable.
- Experience with database security best practices and patch management.
- Good problem-solving skills and ability to troubleshoot complex database issues.
- Strong communication skills to collaborate effectively across technical teams.

Overall Experience:

- 8 to 12 years of relevant experience as a Database Administrator, preferably with MySQL and Oracle.

Education:

- Bachelor's degree in Computer Science, Information Technology, Engineering, Mathematics, or a related field, or equivalent experience.

Supervisory Responsibility:

- None.

Shift Timings:

- 1 P.M. to 10 P.M. IST and one weekend support in a month to support Change Requests (Comp-Off would be provided).

Weekly Hours:

40

Time Type:

Regular

Location:

Hyderabad, India

It is the policy of AT&T to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, AT&T will provide reasonable accommodations for qualified individuals with disabilities. AT&T is a fair chance employer and does not initiate a background check until an offer is made.