With a workforce of over 25,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the sixth largest city in the United States and one of the largest employers in Southeastern Pennsylvania. As an employer, the City of Philadelphia operates through the guiding principles of service, integrity, respect, accountability, collaboration, diversity and inclusion. Through these principles, we strive to effectively deliver services, to resolve the challenges facing our city, and to make Philadelphia a place where all of our residents have the opportunity to reach their potential. 

The Office of Innovation and Technology (OIT) oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia’s businesses, residents and visitors. The OIT Database Group provides database management services to the City’s agencies for mission critical applications deployed on diverse platforms.

The SQL Server Database Administrator is a full performance technologist responsible for providing operational database management services to the City.  This responsibility includes functioning as an experienced professional able to understand and independently implement the standards of OIT’s SQL Server practice. This position reports to the Director of Database Services and receives guidance and direction from Senior SQL Server Database Administrators, and  Principal Database Administrators.

Essential Functions

•    Provides hands-on operational support to the City’s mission critical databases.
•    Performs general Database Administration: DBMS software install, object management, startup and stoppage, patching and upgrade, etc.
•    Identifies performance issues and carries out Performance Tuning.
•    Participate in database software products evaluation.
•    Monitors database management systems (DBMS) and data reporting platforms across the Solution Deployment Life Cycle (Development, Test, Production) and insures that they perform within the expected service level.
•    Participates in the collection of database operations metrics for reports and capacity planning.
•    Execute the established database operation policies, procedures and processes.
•    Understand and execute the database security policies, procedures and processes.
•    Perform reliable backup and restore operations that meet the operations level requirements.
•    Provisions DBMS user access in accordance with the established data management procedures and policies.
•    Participates in the database operation cost accounting and budgeting process.
•    Abides by the various data management compliance requirements: HIPAA, Criminal Justice System, IRS, etc.
•    Regularly communicates with the customer and address or escalate any identified dissatisfaction.
•    Shares technical knowledge with the Database Group team.
•    Tutors and coaches more junior team members.
•    Participates in the review and approval of software solution architectures.
•    Writes database and reporting systems operations automation scripts.
•    Performs various data management operations and configurations: Data ETL(extraction, transformation and load), data replication, data profiling, etc.
•    Create and maintain documentation on architecture, standards, and processes

Competencies, Knowledge, Skills and Abilities

Ability to:
•    Implement and Operate enterprise class database management  and reporting systems.
•    Understand and execute the architecture and design of database management system solutions.
•    Understand and execute data management and data security policies and procedures.
•    Write database and reporting systems operations automation scripts.
•    Work collaboratively
•    Work independently
•    Think systemically
•    Make presentations 

Knowledge Areas:
•    Full operational grasp of SQL Server, including ‘Always on’ and ‘Replication’
•    Operational Knowledge of another database management system used by the City (Oracle, Sybase, ADABAS, etc.)
•    Experience with cloud and open source database offerings is a plus: (MySQL, PostgreSQL, Aurora, Dynamo, MogoDB, MariaDB, Azure SQL Database, AWS RDS, etc.)
•    Operational Knowledge of SQL Server Programming Languages:  TRANSACT-SQL 
•    General Knowledge of Software Programming (mastery of a programming language is a plus).
•    Knowledge of ITSM/ITIL concepts and processes (Incident Management, Change Management, Problem Management, Release Management, etc.)
•    Working Knowledge of Microsoft Office Products: Visio, PowerPoint, Excel, Word
•    Knowledge of a database reporting software:  SSRS, Business Objects, Oracle BI, Power BI, etc.
•    Knowledge of Data Warehousing Concepts is a plus.
•    Knowledge of Information Security Concepts: Identity and Access Management, etc.
•    Knowledge of Network Architecture concepts.

Education
•    Completion of a Bachelor’s Degree program at an accredited college or university which has included a course in computer science, mathematics, business or equivalent.
Experience
•    5 years information technology including extensive database administration or equivalent.
Certifications
•    Database Administration Certification is a plus

Please submit a resume and cover letter with your application.

Salary Range: $80,000 - $95,000

The successful candidate must reside in the City of Philadelphia or establish primary residence in the City of Philadelphia within 6 months of employment

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670

 For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx