Talent.com
This job offer is not available in your country.
Database Engineer

Database Engineer

ConfidentialChennai
13 days ago
Job description

Pay and Benefits :

  • Competitive compensation, including base pay and annual incentive
  • Comprehensive health and life insurance and well-being benefits, based on location
  • Pension / Retirement benefits
  • Paid Time Off and Personal / Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being
  • DTCC offers a flexible / hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee)

The Impact you will have in this role :

  • The Database Administrator will provide database administrative support for all DTCC environments including Development, QA, client test, and our critical high availability production environment and DR Data Centers
  • Extensive knowledge on all aspects of MSSQL database administration and the ability to support other database platforms including both Aurora PostgreSQL and Oracle
  • This DBA will have a high level of impact in the creation of new processes and solutions, while operating under established procedures and processes in a mission critical Financial Services infrastructure environment
  • The Ideal candidate will ensure optimal performance, data security and reliability of our database infrastructure

    • What You'll Do :

  • Software Installation, configure and maintain SQL server instances (On-prem and cloud based)
  • Implement and manage High availability solutions including Always ON availability groups and clustering
  • Support development, QA, PSE and Production environments using ServiceNow ticketing system
  • Review production performance reports for variances from normal operation
  • Optimize SQL queries and indexes for better efficiency
  • Analyze query and recommend the tuning strategies
  • Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products
  • Perform database backup and recovery strategy using tools like SQL server backup, log shipping and other technologies
  • Provide 3rd level support for DTCC critical production environments
  • Participate in root cause analysis for database issues
  • Supports database functions by designing and coding utilities
  • Prepare users by conducting training; providing information; and resolving problems
  • Maintains quality service by establishing and enforcing organizational standards
  • Setup and maintain database replication and clustering solutions
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking innovative practices; participating in professional societies
  • Will have shared responsibility for off-hour support
  • Maintain documentation on database configurations and procedures
  • Provide leadership and direction for the Architecture, Design, Maintenance and L1, L2 and L3 Level Support of a 7 x 24 global infrastructure

    • Qualifications :

    Bachelor's degree or equivalent experience

    Talents Needed for Success :

  • Strong Oracle knowledge of 19c, 21c and 22c
  • A minimum 3+ years of proven relevant experience
  • Solid understanding in MSSQL Server and Aurora Postgres database
  • Strong knowledge in Python and Angular
  • Working knowledge of Oracles Golden gate Replication technology
  • Hands on experience in python, Ansible and other scripting languages to automate the tasks
  • Ability to work with a high degree of latitude while adhering to established process and procedures
  • Good understanding in both how databases fit into systems and how application changes will influence database performance

    • Primary Skills :

  • Proven experience as a Microsoft SQL server Database Administrator (2016 or later)
  • Should have worked as a L2 and L3 Engineer or above in managing large scale MSSQL, Oracle and PostgreSQL environments
  • Demonstrate strong performance Tuning and Optimization skills in MSSQL, PostgreSQL and Oracle databases
  • Good Experience in High Availability and Disaster recovery (HA / DR) options for SQL server
  • Be able to handle tasks and projects independently with minimum guidance and directions
  • Good experience in Backup and restore processes
  • Proficiency in power shell scripting for automation
  • Possess Good interpersonal skills and ability to coordinate with various stakeholders
  • Follow best practices on Organizational change / Incident management / Problem management
  • Good teammate and should have worked with diverse global teams
  • Willing to work on new technologies
  • Demonstrated ability to solve complex systems and database environment issues
  • Demonstrated ability to work in a complex environment to determine business and customer needs and provide the best solution needed
  • Superb communication and collaboration skills

    • Secondary Skills :

  • Strong knowledge on AWS cloud technologies
  • Knowledge on ITIL, Processes would be an added advantage
  • Should be able to understand interlaying technologies like Networking, Applications, and its impact to Database
  • Actual salary is determined based on the role, location, individual experience, skills, and other considerations

    • Role :   Other

    Industry Type :   Financial Services

    Department :   Other

    Employment Type :   Full Time, Permanent

    Role Category :   Other

    Education

    UG :   Any Graduate

    PG :   Any Postgraduate

    Skills Required

    Database Engineer

    Create a job alert for this search

    Database Engineer • Chennai