• 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 :- 23rd Sep 2021

• Responsible for physical database architecture and design, development, performance tuning, implementation, and support of the applications from a database perspective.

• Define and implement database, SQL standards and best practices.

• Work closely with application developers to test, configure, and optimize servers based on application demands.

• Review contention for CPU, memory, network, and disk resources and come up with the remediation plan.

• Identifying, reviewing and resolving Deadlocks and blockings.

• Identifying and .resoling all the DB related long running jobs.

• Ensuring database security, integrity, stability and system availability.

• Work with large volume, heavy load databases

Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.

• Ensure the all the Security patches is applied as per the defined time line.

• Tracking of DB EOL’s/ EOS product version and have the implemenation plan in place for the upgrades or migrations.

• Reporting (on daily basis) tracking and immediate closer for all the Critical and High DB alerts.

• Proactive Capacity planning and resource optimization of all Database Infrastructure.

• Perform In-place /cross platform/ cross Database migrations.

• Maintain the latest security patches/Vulnerability FIX.

• Provide the Outage reports.

• Provide RCA (with 5Why or  Fish  bone methodology) with the complete preventive measures for CRITICAL and HIGH priority incidents/Applications.

• Monitor and maintain system health and security

• Design backup/recovery processes for server and associated data.

• Ensure Regular DB Backup (as per agreed schedule) and recovery is performing.

1. Oracle (9 till 19c) with RAC/DataGuard (HA DR Solutions)

2. MS SQL Server (2008R2 till 2019) (Clustering/Always-On)

3. PostgreSQL/MYSQL (8 till 11).

4. IBM DB2.

5. MySQL

1. Oracle (9 till 19c) with RAC/Data guard implementation and

2. MS SQL Server (2008R2 till 2019) (Clustering/Always-On)

3. PostgreSQL/MYSQL (8 till 11).

4. MySQL

5. IBM DB2