Republic Services Senior Database Administrator-Database Development in Scottsdale, Arizona
Republic Services is an industry leader in U.S. recycling and non-hazardous solid waste. Through our subsidiaries, Republic’s collection companies, recycling centers, transfer stations, and landfills focus on providing effective solutions to make proper waste disposal effortless for our 14 million customers. We’ll handle it from here., our brand promise, lets customers know they can count on Republic to provide a superior experience while fostering a sustainable Blue Planet for future generations to enjoy a cleaner, safer and healthier world.
Why Work with Us
Our Company cannot thrive without great people devoted to serving customers, the community, and the planet. We hire the best people to make Republic a great place to work. We are focused on attracting talented individuals across professions who are as committed to serving customers and the planet as we are. We strive to create a workplace that's meaningful and rewarding to our 33,000 employees. That's why we are proud to be recognized as Best Large Employer by Forbes, World’s Most Ethical Companies by Ethisphere, and One of the Most Meaningful Companies to Work for in America by Business Insider.
This Senior Database Administrator position will be responsible for managing database code, peer reviewing other developers’ work, index strategy, query tuning, and enforcing database system standards. The Sr. DBA will work closely with various development team members in an Agile environment to design and consult on new and existing systems for performance and reliability. As part of a team of database professionals, the Sr. DBA will help maintain and improve Republic Services’ 250+ database servers.
Knowledge, Skills & Abilities
Ensure that new database code meets company standards for readability, reliability, and performance.
Peer-review code from other developers and approve/maintain code in a versioned code repository.
Assist ETL, Report, and other developers to improve the performance of their database code.
Review resource-intensive queries on the server and suggest ways to improve efficiency.
Design indexes for existing applications, choosing when to add or remove indexes.
Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.).
Write and improve SQL Server T-SQL queries, stored procedures, views, and functions.
Use tools and DMV queries to answer questions about index usage and code performance.
Provide guidance and leadership for other team and department members.
Perform other job-related duties as assigned or apparent.
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.
Bachelor’s degree or higher in Information Technology or related field of study (Required).
Minimum 5 years applicable experience with the following: (Required)
Development and support in multiple database systems such as SQL Server, Oracle, and mysql.
Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals.
SQL Server 2012 and higher on virtualized platforms.
Database architectural design and performance assessments.
Windows Server 2008 R2 and higher.
Writing database server code, preferably T-SQL (Required).
Possess expert knowledge of the entire Software Development Lifecycle (SDLC).
Capable of prioritizing and managing assignments, tasks, and significant projects to completion with minimal supervision.
Ability to maintain a detail-oriented approach while multitasking in a fast-paced environment.
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 work in a team and individually in a project environment.
Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner.
History of success in multi-phase projects and development in agile sprints. 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.
401(k) plan with a generous company match.
Employee Stock Purchase Plan (ESPP).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, genetic information, or any other characteristic protected by applicable law.