Sr Database Admin/Engineer

POSITION SUMMARY: 

The Senior Database Administrator/Engineer installs, configures upgrades, administers, and monitors the enterprise database systems of Republic Services. The Senior Database 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.

PRINCIPLE RESPONSIBILITIES:

• 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.

QUALIFICATIONS:

• 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.
• Experience writing database server code
• Possess expert knowledge of the entire Software Development Lifecycle (Waterfall and Agile)
• Experience designing and maintaining NOSQL databases along with MongoDB, more specifically DynamoDB.
• Knowledge of Big Data and Snowflake is a plus
• Knowledge of MDM is a plus
• 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 write reports, business correspondence, and procedures manuals
• Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner
• 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 write reports, business correspondence, and procedures manuals
• Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner

MINIMUM QUALIFICATIONS: 

• 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 NoSQL database systems such as DynamoDB, MarkLogic, Mongo DB, Hadoop. (Required)
• Minimum 2 years applicable experience in Cloud environments such as AWS, Google, Microsoft Azure, Oracle Cloud. (Required)

Rewarding Compensation and Benefits

Eligible employees can elect to participate in:
• C