Sr Database Admin/Engineer

Republic Services

About The Position

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: • 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). • Employee discount programs. • Retirement plan with a generous company match. • Employee Stock Purchase Plan (ESPP). • Paid Time Off (PTO) • Benefits: https://jobs.republicservices.com/us/en/about-us/benefits The statements used herein are intended to describe the general nature and level of the work being performed by an employee in this position, and are not intended to be construed as an exhaustive list of responsibilities, duties and skills required by an incumbent so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company. EEO STATEMENT:Republic Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, relationship or association with a protected veteran (spouses or other family members), genetic information, or any other characteristic protected by applicable law. ABOUT THE COMPANY Republic Services, Inc. (NYSE: RSG) is a leader in the environmental services industry. We provide customers with the most complete set of products and services, including recycling, waste, special waste, hazardous waste and field services. Our industry-leading commitments to advance circularity and support decarbonization are helping deliver on our vision to partner with customers to create a more sustainable world. In 2023, Republic’s total company revenue was $14.9 billion, and adjusted EBITDA was $4.4 billion. We serve 13 million customers and operate more than 1,000 locations, including collection and transfer stations, recycling and polymer centers, treatment facilities, and landfills. Although we operate across North America, the collection, recycling, treatment, or disposal of materials is a local business, and the dynamics and opportunities differ in each market we serve. By combining local operational management with standardized business practices, we drive greater operating efficiencies across the company while maintaining day-to-day operational decisions at the local level, closest to the customer. Our customers, including small businesses, major corporations and municipalities, want a partner with the expertise and capabilities to effectively manage their multiple recycling and waste streams. They choose Republic Services because we are committed to exceeding their expectations and helping them achieve their sustainability goals. Our 41,000 team members understand that it's not just what we do that matters, but how we do it. Our company values guide our daily actions: Safe: We protect the livelihoods of our colleagues and communities. Committed to Serve: We go above and beyond to exceed our customers’ expectations. Environmentally Responsible: We take action to improve our environment. Driven: We deliver results in the right way. Human-Centered: We respect the dignity and unique potential of every person. We are proud of our high employee engagement score of 86. We have an inclusive and diverse culture where every voice counts. In addition, our team positively impacted 4.6 million people in 2023 through the Republic Services Charitable Foundation and local community grants. These projects are designed to meet the specific needs of the communities we serve, with a focus on building sustainable neighborhoods. STRATEGY Republic Services’ strategy is designed to generate profitable growth. Through acquisitions and industry advancements, we safely and sustainably manage our customers’ multiple waste streams through a North American footprint of vertically integrated assets. We focus on three areas of growth to meet the increasing needs of our customers: recycling and waste, environmental solutions and sustainability innovation. With our integrated approach, strengthening our position in one area advances other areas of our business. For example, as we grow volume in recycling and waste, we collect additional material to bolster our circularity capabilities. And as we expand environmental solutions, we drive additional opportunities to provide these services to our existing recycling and waste customers. Recycling and Waste We continue to expand our recycling and waste business footprint throughout North America through organic growth and targeted acquisitions. The 13 million customers we serve and our more than 5 million pick-ups per day provide us with a distinct advantage. We aggregate materials at scale, unlocking new opportunities for advanced recycling. In addition, we are cross-selling new products and services to better meet our customers’ specific needs. Environmental Solutions Our comprehensive environmental solutions capabilities help customers safely manage their most technical waste streams. We are expanding both our capabilities and our geographic footprint. We see strong growth opportunities for our offerings, including PFAS remediation, an increasing customer need. SUSTAINABILITY INNOVATION Republic’s recent innovations to advance circularity and decarbonization demonstrate our unique ability to leverage sustainability as a platform for growth. The Republic Services Polymer Center is the nation’s first integrated plastics recycling facility. This innovative site processes rigid plastics from our recycling centers, producing recycled materials that promote true bottle-to-bottle circularity. We also formed Blue Polymers, a joint venture with Ravago, to develop facilities that will further process plastic material from our Polymer Centers to help meet the growing demand for sustainable packaging. We are building a network of Polymer Centers and Blue Polymer facilities across North America. We continue to advance decarbonization at our landfills. As demand for renewable energy continues to grow, we have 70 landfill gas-to-energy projects in operation and plan to expand our portfolio to 115 projects by 2028. RECENT RECOGNITION Barron’s 100 Most Sustainable Companies CDP Discloser Dow Jones Sustainability Indices Ethisphere’s World’s Most Ethical Companies Fortune World’s Most Admired Companies Great Place to Work Sustainability Yearbook S&P Global Why Work With Us Republic Services is a place where your effort is always appreciated and your teammates always have your back. When you give us your best, we give you ours. We’re constantly investing in new tools and technology that allow you to do your job safely and effectively. We offer plenty of opportunities to learn and grow within your role. And when we say “Sustainability in Action,” we mean it. Together, we’re leaving the world better than we found it through the work we do every day. Are you in? Keep reading to learn more about the position we’re hiring for.

Requirements

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

Nice To Haves

Knowledge of Big Data and Snowflake is a plus
Knowledge of MDM is a plus

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.