**Req ID**: 259227
We are currently seeking a Database Administrator to join our team in México, México (MX-MEX), Mexico (MX).
"
- Manage and oversee the entire lifecycle of SQL Server databases, from development to mission-critical production systems, including SQL Server clusters, SSIS and SSRS infrastructure.
- Configure, monitor, and maintain database servers and processes to ensure high levels of performance, availability, security, and compliance.
- Perform scheduled maintenance tasks and support release deployment activities outside of regular working hours.
- Provide 24x7 support for critical production systems, promptly addressing any issues that may arise.
- Monitor and troubleshoot database systems, ensuring data integrity, security, and optimal performance.
- Develop and implement strategies for data protection and lifecycle management, including backup and recovery, disaster recovery, data retention, and capacity planning.
- Independently analyze and resolve database issues in real-time, providing end-to-end problem resolution.
- Collaborate with developers to review SQL code for performance, scalability, and security optimizations.
- Analyze indexes and execution plans to identify performance improvements and provide guidance on optimal T-SQL coding standards.
- Assist engineering teams in troubleshooting and optimizing queries, stored procedures, views, and functions to address performance issues.
- Utilize industry best practices and coding techniques to refine operational procedures and processes, ensuring solution reliability.
- Maintain comprehensive documentation of database schema changes, ETL processes, and other relevant information in a SQL Server production environment.
- Evaluate the benefits of new SQL Server features and versions, making recommendations for their adoption when appropriate.
- Create and maintain detailed documentation, including diagrams of the database infrastructure.
- Gain a deep understanding of relevant business processes, data flow, criticality, and dependencies.
- Troubleshoot and develop SSIS packages as needed.
- Collaborate with engineers to create optimized SQL code and provide technical mentorship and cross-training to team members.
What you will bring:
- Proven experience as a hands-on Database Operations Engineer, with a strong background in both Database Administration and Database Engineering.
- Bachelor's degree in a relevant field or equivalent experience.
- 10+ years of experience in Database Administration and Database Engineering.
- Advanced knowledge of Microsoft SQL Server.
- Strong understanding of RDBMS concepts, database architecture, and SQL/T-SQL.
- Proficiency in database security concepts, including data encryption at rest and in transit.
- Experience with SQL Server Profiler for monitoring and troubleshooting database activity and performance.
- Proficiency in SQL Server Clustering and HA technologies, such as mirroring, log shipping, Always On, block-level replication, and failover clusters.
- Strong knowledge of SQL Server change data capture (CDC).
- In-depth experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- Expertise in T-SQL DDL/DML, including stored procedures, functions, CLR, triggers, cursors, SMO, query plans, hints, partitioning, and OLAP.
- Solid understanding of SQL Server isolation levels, transaction processing, batch processing, lock escalation, and error handling fundamentals.
- Ability to write complex SQL queries involving multiple tables and inner and outer joins.
- Familiarity with snapshot isolation models in SQL Server.
- Knowledge of ETL tools and experience in ETL development and data integration.
- Strong problem-solving skills and a desire to learn new technologies.
- Excellent written and oral communication skills.
- Strong knowledge of version control systems, such as Git.
- Familiarity with Linux, Terraform, Python, Java, and NoSQL databases is a plus.
- Experience in the healthcare industry is a plus."
LI-LATAM
**About NTT DATA Services**
**NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.
