Database Administrator

Minimum Education: Bachelors’ Degree in Computer Science (or equivalent) and Engineering (or equivalent)
Experience: 5-7 years related experience

Duties :
The candidate is expected to understand business systems, processes and activities to offer comprehensive systems and Database Administration solutions with respect to Configuration, Administration, Monitoring, Security Management, Performance Tuning, Backup/Restore and troubleshooting. The candidate has to Configure and tune databases and operating system software to ensure optimum performance and resource utilization. He / She should function as the technical liaison between Application development, support and other DBA team/s, enforce enterprise security policies and procedures on databases. Candidate should be able to do implementation, configuring data source, queues/topics & deployment of code etc. with excellent analytical problem-solving skills.

Requirement Analysis

• Analyze the Requirements from multiple teams (Development, Reporting, BA) collaborating with Business Operational users and Implement the requirements.
• Collaborate with Third Party Admins, Business Analysts and support along with other architects and System analysts to identify data requirements by each business departments.

Database Design/optimization process

• Establish, oversee, and optimize all database maintenance & backup processes.
• Create system design specifications based on the requirements gathered, which will include database parameters or specifications.
• Create Data Design artifacts that define technical data specifications, and transformation rules; and deliver, gap analysis, impact analysis.

Project execution

• Prepare, maintain and execute disaster recovery plans and delivery methodologies.
• Query performance optimization, tuning implementations.
• Manage backup and recovery of databases.
• Monitor and report system performance and resource consumption trends to assure production systems meet availability requirements
• Create data backup to prevent loss of information and provide technical support for Database maintenance and resolve issues.
• Monitor databases for errors and perform problem determination when necessary. Develop process automation scripts to enhance the efficiency of operations

Database Testing

• Participate in release planning and help development team to accordingly deploying the changes in to production, UAT and QA environment.

Project Documentation and Quality Standards/procedures

• Establish standards, controls, and procedures to ensure data integrity and security.
• Follow and implement the enterprise wide standards on data governance, privacy while designing and development of databases, security framework and data archival
• Maintain Data dictionary, meta data management, Master Data management and reference data management, naming convention and develop procedures to be followed by developers.
• Document and communicate database schemas, using accepted notations, development standards and performance metrics.

Team Coordination / Client Interaction

• Provide assistance to developers in DBMS performance tuning, best practices architecture and problem resolution.
• Design user interface self-service tool to enable business users to create reports as per their requirements.
• Design new databases and integrate them with business tools
• Configure databases with various clients and resolve user issues.