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