Lead DBA - SQL DBA

Job Description

Position Summary & Key Areas of Responsibility

• You will be joining the Software Engineering team based in Hyderabad and working on NCR s Transaction Switching Product (Authentic) which serves several major industries - Financial Services, Retail and Digital Banking.
• In this role, you will be part of a team consisting of other Product Development DBAs, Architects and Senior Developers responsible for enabling several scrum teams, located in London and India, to add and enhance features in this Enterprise level and performance critical application.
• A key focus will be on developing and improving the high availability, failover and the resilience capabilities of the solution and investigating the tools and defining the approach to achieve this.
• In addition to supporting the various deployment choices of our customers, including Active-Passive, Active-Active, clustering, replication & archiving, containerization, cloud deployment and rolling updates as part of a CD/CI pipeline, all across the Databases supported which includes, Postgres, Oracle and MSSQL.
• The role is hands-on requiring, in addition to technical abilities and database knowledge, analytical, organizational and interpersonal skills and a commitment to Product quality.
• You will need to prioritize, make tradeoffs, clarify requirements, determine the appropriate functional implementation and communicate ideas and results to colleagues, management and stakeholders.
• The Software Engineering team operates under Agile as part of a SAFe release train.

Your responsibilities will include:

• Develop, implement and prove high availability, failover and the resilience options and recommend changes to the application to support these.
• Support for live site issues as a member of level 4 support team i.e. development team
• Provide guidance on best practices for replication & archiving and assist the teams with implementations.
• Support various deployment options Active-Passive, Active-Active, clustering etc.
• Work on containerization and cloud deployment.
• Provide mechanisms and guidance to enable rolling updates of the database structure and data as part of a CD/CI pipeline and customer upgrades.
• Investigate, prove and recommend tools and approaches.
• Install, maintain and support the Development and QA databases.
• Assist with the performance tuning of the application.
• Provide, review and update materials to support customer installation, upgrades, maintenance and operational housekeeping of their deployment of the solution.
• Carry out research and PoCs to prove potential additions to the solution and provide recommends.
• Assist the teams with database design and script creation, providing guidance, patterns, best practices and standards and enforce those standards.
• Ensure Data and Application Security.
• Troubleshoot complex database issues.

Basic Qualifications & Experience

• 5+ years experience as a DBA working with either Postgres or MSSQL.
• Willingness to learn and work on multiple databases
• Strong working knowledge of RDBMS high availability solutions.
• Strong working knowledge of RDBMS performance tuning.
• Experience working on large products for external enterprise customers.
• Ability to thoroughly understand complex business and technical issues related to databases and influence decision making.
• Proven ability/experience to work with virtual teams.
• Ability to work both independently and as part of a team.
• Quick learner, willing to take initiative, enthusiastic about work, determined and thorough.
• Good communication skills.

Preferred Qualifications & Experience

• 3+ years experience working in Product development would be an advantage.
• Experience in the Payments industry would be an advantage.
• Experience of micro-services, containerization or cloud would be an advantage.
• Experience working on a high-volume transaction system.
• Knowledge of Agile development practices (especially Scrum), methodologies and tools or SAFe.

Keyskills :
backupdatabase administrationperformance tuningsqlsql serverdatabase designoracle financialsagile developmenthigh availabilityfinancial servicesproduct developmentsoftware engineeringapplication securityinterpersonal skillsproject administra