ESaaS - Oracle - DBA - Apps

Zensar Technologies; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Zensar Technologies in Pune, India is seeking an experienced SQL Server DBA to design, implement, maintain, and optimize Microsoft SQL Server databases. The role ensures availability, security, and performance while collaborating with development teams to deliver efficient database solutions.

You will manage migrations, backups, security, and disaster recovery, and automate maintenance tasks using T-SQL and PowerShell in a enterprise environment.

Qualifications

• Bachelor's degree in CS/IT or related field.
• Proven experience as SQL Server Database Administrator.
• In-depth knowledge of Microsoft SQL Server versions and related technologies.
• Proficiency in writing and optimizing SQL queries.
• Strong understanding of database security, backup, and recovery.
• Familiarity with high availability and disaster recovery concepts.
• Scripting skills (e.g., T-SQL, PowerShell) for automation.
• Excellent problem-solving and troubleshooting abilities.
• Strong communication and collaboration skills.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.

Responsibilities

• Install, configure, and upgrade SQL Server instances.
• Create and manage database objects, such as tables, indexes, views, and stored procedures.
• Monitor and maintain database performance, including query optimization and troubleshooting.
• Database Migration using the backup/restore method.
• Detach/Copy/Attach databases from the source SQL server instance to target.
• In place / Side by side DB migration.
• Develop and implement database backup and recovery strategies.
• Regularly perform database backups and verify their integrity.
• Plan and conduct disaster recovery tests to ensure data availability.
• Implement and manage database security measures, including access control and user authentication.
• Monitor and audit user activities to ensure data security and compliance with regulations.
• Identify and resolve performance issues, such as slow queries and resource bottlenecks.
• Optimize database configurations for better overall performance.
• Configure and manage database replication, clustering, and mirroring for high availability.
• Implement failover mechanisms to minimize downtime in case of server failures.
• Monitor database growth and resource utilization.
• Plan for and implement necessary scaling strategies to accommodate data growth.
• Develop scripts and automate routine database maintenance tasks.
• Implement database deployment automation processes.
• Collaborate with development teams to optimize SQL queries and improve database design.
• Work with IT teams to ensure seamless integration of databases with applications.
• Maintain accurate and up-to-date documentation of database configurations, procedures, and policies.

Skills

SQL Server proficiency

T-SQL scripting

PowerShell scripting

Problem-solving

Communication

Education

Bachelor's degree in Computer Science/Information Technology or related field

Tools

Microsoft SQL Server

Azure SQL / Azure Database

Job description

Job Description:

The SQL Server Database Administrator (DBA) is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server databases. The role involves ensuring the availability, security, performance, and integrity of databases, as well as collaborating with development teams and other IT professionals to deliver efficient database solutions.

Responsibilities

1. Database Management:
   • Install, configure, and upgrade SQL Server instances.
   • Create and manage database objects, such as tables, indexes, views, and stored procedures.
   • Monitor and maintain database performance, including query optimization and troubleshooting.
2. SQL Server Migration and Upgrade
   • Database Migration using the backup/restore method.
   • Detach/Copy/Attach databases from the source SQL server instance to target.
   • In place / Side by side DB migration.
3. Backup and Recovery:
   • Develop and implement database backup and recovery strategies.
   • Regularly perform database backups and verify their integrity.
   • Plan and conduct disaster recovery tests to ensure data availability.
4. Security:
   • Implement and manage database security measures, including access control and user authentication.
   • Monitor and audit user activities to ensure data security and compliance with regulations.
5. Performance Tuning:
   • Identify and resolve performance issues, such as slow queries and resource bottlenecks.
   • Optimize database configurations for better overall performance.
6. High Availability:
   • Configure and manage database replication, clustering, and mirroring for high availability.
   • Implement failover mechanisms to minimize downtime in case of server failures.
7. Capacity Planning:
   • Monitor database growth and resource utilization.
   • Plan for and implement necessary scaling strategies to accommodate data growth.
8. Automation:
   • Develop scripts and automate routine database maintenance tasks.
   • Implement database deployment automation processes.
9. Collaboration:
   • Collaborate with development teams to optimize SQL queries and improve database design.
   • Work with IT teams to ensure seamless integration of databases with applications.
10. Documentation:
    • Maintain accurate and up-to-date documentation of database configurations, procedures, and policies.

Qualifications

• Bachelors degree in Computer Science, Information Technology, or related field (or equivalent experience).
• Proven experience as a SQL Server Database Administrator.
• In-depth knowledge of Microsoft SQL Server versions and related technologies.
• Proficiency in writing and optimizing SQL queries.
• Strong understanding of database security, backup, and recovery.
• Familiarity with high availability and disaster recovery concepts.
• Scripting skills (e.g., T-SQL, PowerShell) for automation.
• Excellent problem-solving and troubleshooting abilities.
• Strong communication and collaboration skills.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.

At Zensar, we're "experience-led everything". We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we're a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensarand join us to Grow. Own. Achieve. Learn.to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.