IND (New) SQL DBA

Hyderabad, Telangana, India | Product and Technology | Full-time | COVID-19 remote

Apply

Role summary

The SQL DBA is responsible for installing, monitoring, maintaining, and performance tune production Microsoft SQL databases while ensuring high levels of data availability. This role will be responsible for developing, implementing, and overseeing Microsoft SQL database policies and procedures to ensure the integrity and availability of databases and their accompanying softkey.

Responsibilities

Strategy & Planning

  • Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Acquisition & Deployment

  • Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management

  • Install and configure relevant network components to ensure database access as well as database consistency and integrity.
  • Respond to and resolve database access and performance issues.
  • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Monitor, optimize, and allocate physical data storage for database systems.
  • Plan and coordinate data migrations between systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Perform database transaction and security audits.
  • Establish appropriate end-user database access control levels.
  • Develop routines for end users to facilitate best practices database use.
  • Manage and/or provide guidance to junior members of the team.

Key activities

  • Participate in, and provide expert advice, in the assessment and development of long-term strategic goals for production databases in concurrence with both data owners and department managers
  • Ensure that the necessary installation and configuration is in place for the relevant network components to ensure database access as well as database consistency and integrity.
  • Communicate and deliver recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
  • Amend and adjust the overall database systems within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Build great rapport with the key business stakeholders to be considered a Senior Database Administrator. This should be facilitated via regular meetings with stakeholders to communicate findings and make any recommendations that will support any findings.

Experience and education required

  • 3 + years in a similar role, ideally in a professional services or Technology environment
  • Strong understanding of database structures, theories, principles, and practices.
  • Working technical experience with designing, building, installing, configuring, and supporting MS SQL database servers
  • Hands-on MS SQL database tuning and troubleshooting experience.
  • Execution Plan, Database Tuning Advisor (DTA) and Resource Management\Monitoring)
  • Experience with data processing flowcharting techniques.
  • Project management experience.
  • Strong understanding of the organization’s goals and objectives.
  • Knowledge of applicable data privacy practices, laws and security control.
  • Well-developed interpersonal skills, with the ability to work with a broad range of subject matter experts is needed
  • An eye for detail, with the ability to summarise complex information and effectively communicate recommendations.
  • A strong track record working both individually, and as part of a busy team
  • Exceptional English – both written and verbal