Required Skills

Postgre SQL

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 :- 21st Feb 2024

JOB DETAIL

As a Senior Database Administrator, responsibilities include:

•            Migration

o            Experience with On-Prem to Cloud Migrations (Backup/Restore, Export/Import, Load Testing, Bench Marking Old Vs New Environments)

o            Act as the PostgreSQL SME to provide expert level of migration expertise

o            Ensuring timely completion of migration tasks

•            Real time monitoring

o            Proactively monitor and manage a large database infrastructure across multiple applications

•            Troubleshooting

o            Provide expert level troubleshooting to quickly identify and resolve database related incidents across a wide array of technologies and platforms

o            Responsible for participating in root cause analysis and problem resolution

o            Makes technical decisions during high priority incidents focused on impact remediation and communicates clearly to call participants and leadership

o            Perform updates/changes during maintenance windows

o            Understand current capacity issues and the capacity planning processes

o            Work with team to review change requests

o            Participate in software deployments

o            Assimilate organizational objectives into operational action plans

•            Change Management

o            Support a rigorous change control process including creating, reviewing, approving, and implementing change records for database activities

•            Vendor Management

o            Engage, drive, and escalate issues with database vendors related to incident management

•            Problem Management

o            Support a rigorous problem management process including problem creation and review database activities

•            Other duties as assigned

o            Participate in special projects representing database operations on new implementations or troubleshooting deep dives

o            Identify opportunities for automation of manual tasks

 

You’re the type of person who:

•            Has excellent communication skills and the ability to deal with clients, vendors, engineers, and managers at various levels

•            Has the ability to communicate technical concepts to non-technical employees

•            Has the ability to manage and prioritize multiple incidents with potentially competing priorities

•            Collaborates well with others to solve problems and actively incorporates input from multiple sources

•            Has the ability to work with a global team and apply knowledge to coach and mentor team members as required

•            Is self-motivated, detail oriented, organized, thorough, and able to think “outside the box”

•            Has a strong desire to learn and grow

Basic qualifications for consideration:

•            Bachelor’s degree in computer science, business, or information technology or equivalent work experience

o            At least 8+ years’ experience working as a PostgreSQL Server DBA in an Enterprise environment.

•            Experience with backup processes & procedures

•            Excellent communication (spoken and written) skills

•            The ability to document standard operational procedures

•            Knowledge and experience with capacity planning as it pertains to databases

•            Ability to work Autonomously and as part of a team

•            Other Database Platform (Oracle, SQL, DB2, etc.) skills are plus.

Preferred Skills, Experience, and Education:

•            Experience with Cloud Technology concepts, topologies, and service models (PaaS/SaaS/IaaS, Azure, AWS) is a plus

•            Hands-on experience working with various recent versions of PostgreSQL. Experience with MS SQL and/or DB2 SQL is a big plus

•            Knowledge and experience with database management and other monitoring tools (Foglight, Splunk, Extrahop, Dynatrace, etc.)

•            Hands-on experience working with Server partition design and implement.

•            Knowledge and experience on database HA/ DR design and implementation, always-on grouping, replication, mirroring, and log shipping.

•            Knowledge and experience on design and support large database migration strategy.

•            Hands-on experience working with in-place database upgrade experiences on VM and physical servers.

•            Knowledge and experience on database service broker (or similar) troubleshooting is a plus

•            PostgreSQL Certifications are preferred, MCSE/DB2 Certifications are a plus

•            Travel required: Less than 5% travel

 

Company Information