• Oracle with PostgreSQL Administrator

Industry : IT
Location : Gurgaon

Functional: IT Software - Application Programming / Maintenance
Job Description
About Us :
Spectrum Talent Management is a comprehensive HR services company offering solutions spanning the entire talent life cycle including Recruitment, Onboarding, Payroll and Flexible Staffing. Founded in 2008, we are a continuously growing, yet mature service firm specializing in recruitment and staffing requirements of global organizations. Our leadership and high acceptance in the market is evident by the phenomenal growth that we have demonstrated in just few years of our inception. From Permanent recruitment to Flexi staffing, Payroll management to RPO, the orbit of the value add that we provide our customers with has always evolved, and diversified from time to time. This has enabled us to become a preferred vendor with most of our clients.
About Company :
Our client builds new ways to make technology and health care work better for millions of people every day, from the most advanced development tools to the highest levels. They’re building incredible solutions every day by bringing out the best in their technology teams, and if you’re in, you’ll be challenged like never before! Join the team that’s changing the future of health care.
Roles and Responsibility :

This DBA position is in our infrastructure team. Primary skills we are looking for is Oracle & PostgreSQL.

You will work closely with our DevOps teams to install / configure and operationally manage database clusters including applying database patching, supporting database backups and restores, working on any performance tuning requirements and live monitoring of databases. You will be required to participate in Production On-Call rotation.

?Install / configure and operationally manage standalone & database clusters

?Monitor/ Remediate alerts and provide Operational support for Oracle/PostgreSQL databases

?Monitoring Oracle database performance using tools such as Stats pack, AWR, ADDM, ASH and SQL advisors and recommend tuning options.

?Monitoring Oracle ASM storage; perform adding, resizing of data files, space management on disk groups, rebalancing of disks, etc.

?As needed, perform Oracle DB backup and recovery using RMAN, Hot Backup, Data pump, cloning techniques.

?In PostgreSQL, experience in Installation, configuration of pgBouncer for connection pooling & of rules in pg_hba.conf. Backups/ restoration using pg_dump/pg_basebackup & pg_restore utilities.

?Performing DB patching, investigate and remediate vulnerabilities.

?Collaborate with application developers and troubleshoot issues

?Develop automated scripting / assist in manual deployments for application code as needed and promote DevOps

?Willingness and ability to provide rotational 24x7 on-call support

?5-7 years of Oracle DBA experience with some exposure to PostgreSQL DB

?Database installation / configuration and performance tuning skills

?Experience with Oracle RAC

?Experience monitoring and resolving Oracle OEM Grid Alerts

?Experience with Data Guard for switchover/failover

?Database administration experience with  Oracle Databases on Exadata

?Excellent organizational, verbal, and written communication skills

?Willingness and flexibility to cross train in new DBA technologies and tools as part of today?s DevOps landscape

?Bachelor?s Degree in Computer Science or related field

?Experience in Open source databases such as Cassandra and MySQL

?Professional experience in the Health Care industry


Recruiter Name : Priyanshu Saxena
Recruiter Number : 7290057790
Recruiter Email Id : priyanshu@spectrumtalentmanagement.com
A+| A| A-