• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 29th Jul 2021

 

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