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 :- 22nd 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.
Mandatory Core level expert (Primary) in any (or all) of the below technology.
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