10+ years of DBA experience in RDMBS systemsPostgres requiredSnowflake5+ years of experience in NoSQL such as MongoDBDynamoDB
Work Authorization
US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Employment Type
Consulting/Contract
education qualification
UG :- - Not Required
PG :- - Not Required
Other Information
No of position :- ( 1 )
Post :- 5th Oct 2024
JOB DETAIL
Ownership in installations, creation, management, monitoring, scaling and tuning RDMBS and NoSQL databases for various business units.
Day to day management activities of production databases for online system operations including monitoring, troubleshooting, backup, restore, change management, and storage management.
Responsible for Database Replay, Partitioning, Schema Management, Resiliency, Virtual columns, Making, and Security.
Working knowledge in monitoring, optimization, configuration, troubleshooting, manage data replication, backups, partitioning, and storage management the database platforms.
Run performance, management, and tuning tools.
Participate in discussions and recommend new strategies for installation, upgrade, configuration, and patching of new and existing RDBMS and NoSQL platforms.
Recommend new strategies and architectures for high availability, monitoring, database security, backup, and recovery for large scale databases.
Strong knowledge with AWS RDBMS RDS platforms and EC2.
Ability to participate in an on-call rotation to provide production support in a 24/7 environment.
Comply with all company policies and procedures.
Maintain regular and punctual attendance.
Strong Experience in development of stored procedures, packages, triggers, SQL queries, reports, and scripts.
Expertise in Database Replay, Partitioning, Schema Management, Caching and Pooling, Resiliency, Masking, and Security.
Hands on experience with various performance and tuning tools such as ASH, AWR, STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF and ADDM reports.
Proficiency in troubleshooting, performance tuning and SQL optimization.
Ability to diagnose problems and resolve issues across various tiers (application, database, network, server, and storage)
Strong Experience with data migration, data archiving and data access techniques.
Must be able to write SQL and UNIX shell scripts with formatting to serve as evidence for the change management process.
Evaluate new database technologies and products and recommend to technical management.
Scripting language skills such as Perl, Python, and Bash is a strong plus.
Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams.