Sr Database Admin​/Engineer

The Senior Database Administrator/Engineer installs, configures upgrades, administers, and monitors the enterprise database systems of Republic Services. The Senior Administrator/Engineer also works closely with the Infrastructure and Applications team to design and consult on new and existing systems to optimize performance and reliability.

Manage, monitor, and optimize relational databases including Oracle and SQL Server along with other platforms.

Manage and optimize cloud database services (AWS RDS/Aurora, Azure SQL, google cloud services).

Design and implement cloud-based database architectures including migrations from on-prem to cloud.

Design scalable, secure, and high-performance database architectures for both on-prem and cloud environments.

Perform stored procedure tuning, including rewriting inefficient code, optimizing logic flow, enhancing execution efficiency, and reducing resource consumption.

Manages installation, patching and upgrades on all enterprise database systems.

Manages user provisioning and security on all enterprise database systems.

Maintains the integrity of data within the production environment, including the execution of proper backup and restoration policies and procedures.

Provides guidance and input on the selection and implementation of all database administration tools.

Administers database cleanup and optimization activities.

Assists with database design, particularly regarding design maintainability and scalability.

Prepares detailed technical specifications.

Provides assistance in database programming, troubleshooting and management of problems affecting IT and enterprise database applications, as well as developing the area for future expansion.

Provides escalated support and resolution of open database issues from IT Customer Support.

Manages and reviews code for deployment and promotion from development environments into QA and production systems.

Monitors performance metrics and makes enhancements or suggestions on design and infrastructure, as necessary.

Plans and projects system capacity requirements for budgeting and licensing purposes.

Provides guidance, mentors staff and developers, and acts as technical escalation point for the team.

Provides database best practices and standards, performance testing, and R&D.

Develops strong vendor relationships to resolve problems and coordinates the delivery of IT products and services.

Provides on-call support on a rotating schedule.

Performs other job-related duties as assigned or apparent.

Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals.

SQL Server 2016 and higher on virtualized platforms.

Database architectural design and performance assessments.

Possess expert knowledge of the entire Software Development Lifecycle (Waterfall and Agile)

Capable of prioritizing and managing assignments, tasks, and significant projects to completion with minimal supervision.

Ability to create and maintain documentation of development standards in use at Republic Services.

Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner

Minimum 5 years applicable experience in two or more relational database systems such as SQL Server (2012 or higher), Oracle (12c or higher), and MySQL. (Required)

Minimum 2 years applicable experience in No

SQL database systems such as Dynamo

DB, Mark Logic, Mongo DB, Hadoop. (Required)

Minimum 2 years applicable experience in Cloud environments such as AWS, Google, Microsoft Azure, Oracle Cloud. (Required)

• Comprehensive medical benefits coverage, dental plans and vision coverage.
• Health care and dependent care spending accounts.
• Short- and long-term disability.
• Life insurance and accidental death & dismemberment insurance.
• Employee and Family Assistance Program (EAP).
• Retirement plan with…