TechnicalLead-DatabaseEngineer(OracleDBA, RMAN,Postgres, Performance Tuning,Shell/Bash scripting, AWS)
IN-Hyderabad
Our fast-paced and collaborative environment inspires us to create, think, and challenge each other in ways that make our solutions and our teams better. Whether you’re interested in engineering or development, marketing or sales, or something else – if this sounds like you, then we’d love to hear from you!
We are headquartered in Denver, Colorado, with offices in the US, Canada, and India.
JOB DESCRIPTION
As an Oracle Database Engineer, you will be responsible for database administration, design, development, and support applications available systems. You will be responsible for continuously enhancing the automation process of the database and should have an interest in DevOps to help us improve our software engineering practices. You will require to work closely with multiple stakeholders in order to understand their database needs. After understanding their needs, you will make recommendations and provide self-service offerings that will allow stakeholders to deploy, monitor, backup and maintain their databases for business need.
You will work with a fast-paced, skilled team of engineers, DBA’s, and developers across multiple high-profile projects. You will also participate in IT projects from inception of the project and daily maintenance phase of those projects. You should have a good understanding of cloud concepts. If you are a top-notch DBA and looking for the next challenge, apply now!
Core Requirements and Responsibilities:
Essential job functions included but are not limited to the following:
· Required: 5+ years experience running a large fleet of Oracle databases at scale, focus on installation, configuration, upgrade, performance, security, scalability, reliability, high-availability, and disaster recovery setup.
· Experience with AWS database administration, on-premises Oracle, Postgres, SQL Server and Mongo database administration, deployments, ideally RDS Postgres and Aurora Postgres, EC2 Oracle
· Experience in installing and upgrading Oracle 19c databases.
· Experience with RMAN database backup and recovery.
· Setup Monitoring, Backup & Recovery, High Available and alerting notification systems on AWS and on-premises.
· Perform analysis, design, implementation, and migration of data and application database code from Oracle to AWS- RDS/Aurora PostgreSQL and EDB PostgreSQL databases.
· Develop automation frameworks (Infrastructure as code, CI/CD pipelines) and tooling that will be consumed by the entire engineering organization.
· Container and container orchestration technologies (e.g. Docker, Kubernetes)
· Cloud-native infrastructure (AWS)
· Linux internals and network configuration and protocols
· Experience in creating shell scripts (Linux, Python is a plus).
· Infrastructure-as-Code and configuration management (Chef, Terraform, Jenkins)
· Experience in Ansible is huge plus.
· Resolve complex problems by investigating and devising solutions for database operations. May include installations, configuration, tuning and maintenance of database management.
- Hands-on end-to-end Database Development encompassing Database Design and Development working with cross-functional teams.
- You should be able to debug application code written in PL SQL and PG SQL for different applications.
- Understand the business priorities and requirements; architect/develop solutions to meet the business need and lead execution.
- Work as an individual contributor and collaborate with multiple teams/vendors/consultants effectively.
· Provides after-hours, weekend support during maintenances and participate in on-call rotation (24X7)
Knowledge, Skills, and Abilities:
- Required: Primary: Oracle (Core), Secondary: SQL Server/Postgres(Mandatory), MongoDB (Desirable)
- Required: Database Automation and scripting experience
- Required: Oracle Performance Tuning & SQL query tuning with experience in PL-SQL
- 5+ years of experience in Oracle administration and scripting experience and Oracle database administration and development experience in AWS environment
- 3+ years of AWS cloud experience and DevOps experience preferred.
- 3+ years of commercial database migration experience Orace/SQL Server to Postgres preferred.
· 2+ years of AWS RDS and Aurora cloud experience preferred.
· 2+ years of SQL Server database administration experience preferred.
- Experience with other databases such as Oracle or SQL Server is preferred.
- AWS RDS/Aurora Postgres or Oracle administration experience desirable
· Experience with Oracle database backups and recovery.
- Enhance automated functions including monitoring, backing up, recovering, increasing availability, user management, access to controls and logging audits.
· Familiarity with standard tools and platforms that enable continuous delivery such as GitLab, Octopus Deploy, Kubernetes and ServiceNow.
· Nice to have experience with multi-tenant systems.
- Demonstrated desire and ability to learn technologies quickly.
- Possesses good oral and written communication skills.
- Contributes to a positive team environment.
- Enjoys finding and implementing solutions to new challenges.
- Proactively asks questions and learns about our products.
- Effectively multi-tasks and adapts to change.
- Strong problem solving and troubleshooting abilities.
- Ability to work productively on various projects simultaneously.
Qualifications:
- Qualification BS or MS
- AWS Certifications
Why Vertafore is the place for you: *Canada Only
- The opportunity to work in a space where modern technology meets a stable and vital industry
- Medical, vision & dental plans
- Life, AD&D
- Short Term and Long Term Disability
- Pension Plan & Employer Match
- Maternity, Paternity and Parental Leave
- Employee and Family Assistance Program (EFAP)
- Education Assistance
- Additional programs - Employee Referral and Internal Recognition
Why Vertafore is the place for you: *US Only
- The opportunity to work in a space where modern technology meets a stable and vital industry
- Vertafore is a Flexible First working environment which allows team members to work from home as often as you’d like, while using our offices as a place for collaboration, community, and teambuilding. There are times you may be asked to come into an office and/or travel for specific meetings for a specific business purpose and this varies by job responsibilities.
- Medical, vision & dental plans
- PPO & high-deductible options
- Health Savings Account & Flexible Spending Accounts Options:
- Health Care FSA
- Dental & Vision FSA
- Dependent Care FSA
- Commuter FSA
- Life, AD&D (Basic & Supplemental), and Disability
- 401(k) Retirement Savings Plain & Employer Match
- Supplemental Plans - Pet insurance, Hospital Indemnity, and Accident Insurance
- Parental Leave & Adoption Assistance
- Employee Assistance Program (EAP)
- Education & Legal Assistance
- Additional programs - Tuition Reimbursement, Employee Referral, Internal Recognition, and Wellness
- Commuter Benefits (Denver)
The selected candidate must be legally authorized to work in the United States.
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all the job responsibilities, duties, skill, or working conditions. In addition, this document does not create an employment contract, implied or otherwise, other than an "at will" relationship.
Vertafore strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other characteristic protected by state or federal law.
The Professional Services (PS) and Customer Success (CX) bonus plans are a quarterly monetary bonus plan based upon individual and practice performance against specific business metrics. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.
The Vertafore Incentive Plan (VIP) is an annual monetary bonus for eligible employees based on both individual and company performance. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.
Commission plans are tailored to each sales role but common components include quota, MBO's and ABPMs. Salespeople receive their formal compensation plan within 30 days of hire.
Vertafore is a drug free workplace and conducts preemployment drug and background screenings.
We do not accept resumes from agencies, headhunters or other suppliers who have not signed a formal agreement with us.
We want to make sure our recruiting process is accessible for everyone. if you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact recruiting@vertafore.com
Just a note, this contact information is for accommodation requests only.