Required Skills

SQL DBA T-SQL scripts MSSQL Administrative

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 12th Jan 2021

JOB DETAIL

JOB DESCRIPTION:

Additionally following key skills required when you filter the profiles,

 

•             Hands on experience in SQLCMD utility.

•             Hands on experience in Invoke-SQLCMD utility.

•             Hands on experience in PowerShell scripting.

•             Hands on experience to script T-SQL scripts for the MSSQL Administrative tasks.

•             Hands on experience to automate the BAU DBA tasks.

•             Hands on experience in solution design the automate the DBA activities.

•             Hands on experience “Foglight Monitoring tool – for MSSQL”, Freddie is using this tool for database monitoring.

•             Should have basic knowledge about the below mentioned automation tools.

o             Ansible scripting.

General Experience:

•             Combined 8+ years or more of IT infrastructure operations management.

•             Motivated to build a career in managing projects in Business Process Automation, orchestration, integration of eco system tools in Infra structure management system.

Soft Skills:

•             Excellent communication and facilitation skills, both written and verbal

•             Strong ability to manage ambiguity effectively and generate results in a matrixed leadership structure

•             Strong team building and negotiating capabilities

•             Ability to operate in regulated business environments that leverage global delivery across multiple IT suppliers

•             Knowledge on Infrastructure management systems and operational support.

DBA Experience :

•             Experience of working in a Automation team that delivers a high availability service.

•             Experience in Customer handling and good communication Skill.

•             Excellent working experience in Oracle 10g/11g and Oracle 12c in windows, Linux, Unix environments.

•             Expertise in Oracle database design, installation, configurations in windows, Linux, Unix environments.

•             Experience in database upgrades, patching, migrations in windows, Linux, Unix environments.

•             Good experience in Backup &  Recovery using RMAN and Data pump.

•             Experience in Database related day-to-day Activities.

•             Experience in Database refreshes and cloning.

•             Experience in Data guard configuration and Administration.

•             Experience in Oracle RAC administration & Configuration.

•             Experience in troubleshooting database ORA issues in windows, Linux, Unix environments.

•             Excellent in Performance Tuning including monitoring, troubleshooting and optimizing performance of the databases using AWR, ADDM.

•             OEM configuration and troubleshooting

•             Should have knowledge in PL/SQL, SQL and Shell scripting.

•             Experience in monitoring and  tuning Database Performance to provide a high availability service.

•             OEM configuration and troubleshooting. 

•             Experience of SQL Server is desirable.

Company Information