TechnicalLead-DatabaseEngineer(OracleDBA, RMAN,Postgres, Performance Tuning,Shell/Bash scripting, AWS)

| Hyderabad, Telangana, IND | Hybrid
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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
Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • ASP.NETFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • AWS (Amazon Web Services)Services

What are Vertafore Perks + Benefits

Culture
Volunteer in local community
Vertafore offers employees 1 paid day to volunteer at the non-profit of their choice.
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Employee resource groups
Employee-led culture committees
Quarterly engagement surveys
Hybrid work model
President's club
Employee awards
Remote work program
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 team buildin
Diversity
Mandated unconscious bias training
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance + Wellness
Flexible Spending Account (FSA)
Vertafore employees can contribute up to $2750 annually to their FSA.
Disability insurance
Disability insurance covers 100% of annual salary for up to 90 days of disability.
Dental insurance
Our dental plan covers $1500 of expenses per person.
Vision insurance
The vision benefits plan covers 100% for annual eye exams with $175 for glasses or contact lenses.
Health insurance
Vertafore offers three different health plans to meet the needs of our employees.
Life insurance
Pet insurance
We offer a Pet Insurance plan through Nationwide.
Wellness programs
Team workouts
Vertafore's team fitness initiatives include in-office yoga, a partnership with Planet Fitness, and other recreational team sports.
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
Vertafore provides employees with a 401(k) matching plan managed by [provider]. We match up to 50% of contributions up to 3% of an employee's annual gross pay.
Employee stock purchase plan
Performance bonus
Pay transparency
Child Care & Parental Leave
Generous parental leave
Family medical leave
Adoption Assistance
We reimburse up to $2,500 for eligible adoption expenses and 6 weeks of paid leave.
Company sponsored family events
Vertafore sponsors family oriented events semi-annually.
Vacation + Time Off
Unlimited vacation policy
Paid volunteer time
Paid holidays
Paid sick days
Bereavement leave benefits
Company-wide vacation
Every year on the second Friday in April, our company shuts down for "Refresh & Recharge Day." It's a day to unplug and get back to what you love outside of work.
Office Perks
Commuter benefits
Company-sponsored outings
Vertafore hosts company outings annually.
Free snacks and drinks
In various areas of the office, Vertafore provides weekly fresh fruit services, bagels and donuts on specified days, as well as snacks and drinks.
Some meals provided
We provide free breakfast on Mondays and Fridays.
Company-sponsored happy hours
Recreational clubs
Vertafore sponsors recreational clubs that include sports, board games, video games, book clubs, etc.
Home-office stipend for remote employees
Onsite gym
Professional Development
Tuition reimbursement
Our tuition reimbursement plan offers an annual max of $5,250.
Lunch and learns
Promote from within
Mentorship program
Vertafore's mentorship framework is an independently led experience between a mentee and a mentor. Resources are ongoingly provided to start this relationship and keep it successful & valuable.
Online course subscriptions available
Personal development training

Additional Perks + Benefits

We felt like the stretch of no three day weekends from Feb - May was too long, so we added our own holiday! We celebrate Vertafore Rest and Recharge day in April, and the whole company has a long weekend.

More Jobs at Vertafore

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about VertaforeFind similar jobs like this