WORKING CONDITIONS

Office environment

24x7 on-call support

MAJOR DUTIES AND RESPONSIBILITIES:

• Actively and consistently supports all efforts to simplify and enhance the customer experience.

• Administer automation platform and assist in code development via Anisble and Oracle Application Express tool set.

• Support internial SSRS and Power Bi report development

• Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.

• Designs and maintains access and security administration.

• Designs, implements and maintains backup and recovery strategies on Database Management Systems.

• Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data

• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

• Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.

• Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.

• Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth.

• Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation.

• Gathers business requirements and designs, implements multiple projects along with the production support.

• Creates standard operational procedures and templates.

• Acts as mentor for Database Administrators and Associate Database Administrators.

• Performs research and provides plans to remediate complex business problems.

• Assists the development teams to improve database design and procedures on PL/TSQL best practices etc.

REQUIRED QUALIFICATIONS:

Skills/Abilities and Knowledge

• Ability to read, write, speak and understand English

• Strong knowledge of database architecture and its implementation

• Strong automation background

• Strong understanding of best practices in maintaining medium to large scale OracleSQL Server database systems

• Strong programing experience

• Strong Strong knowledge of PL/SQL the followingL programming language (TSQL, PowerShell, Ansible, .net)

• Strong understanding of Change Management procedures

• Strong knowledge of Instance, database and query tuning to improve the performance of the database/application

• Strong understanding of SAN technologies related to SQL server disk layouts

• Strong knowledge of Windows/Linux/Solaris operating systems and shell scripting

• Strong Knowledge of SSRS and PowerBi

• Ability to communicate orally and in writing in a clear and straightforward manner

• Ability to communicate with all levels of management and company personnel

• Ability to handle multiple projects and tasks

• Ability to make decisions and solve problems while working under pressure

• Ability to prioritize and organize effectively

• Ability to show judgment and initiative and to accomplish job duties

• Ability to use personal computer and software applications (i.e. word processing, spreadsheet, etc.)

• Ability to work independently

• Ability to work with others to resolve problems, handle requests or situations

• Ability to effectively consult with department managers and leaders