With a workforce of over 25,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the fifth 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 Philadelphia International Airport is a Division under the Commerce Department of the City of Philadelphia. The airport services approximately 82,000 travelers per day. The airport Information Technology Department is headed by the Chief Information Officer (CIO).

The SQL Server Database Administrator position manages multiple databases for the airport’s development and production environments. This position is responsible for database creation, organization, installation, data migration, maintenance, support, backup and restoration of the database environments and its applications.  The SQL Server Database Administrator will work with the IT and user groups to maintain and support the database environments.

Essential Functions
•    Communicates with managerial, administrative and technical staff to determine information needs, data flows and systems definitions
•    Manages the environments, distribution and retention of data to ensure data integrity 
•    Manages and administrates the data structures and maintains an inventory of data definitions
•    Develops policies and procedures related to the support and maintenance of the database and applications
•    Performs database turning to maintain or increase database performance
•    Assist and advise in the performance of tuning SQL queries
•    Provides input for strategic planning, high availability and disaster recovery
•    Performs database administration duties, including installation, configuration patching, recovery management, space management, schema management, startup and shutdown.
•    Ensures all databases are backed up to meet Airport’s recovery objectives
•    Test backups to ensure Airport’s recovery objectives can be met
•    Reviews proposed changes to database to evaluate effects on logical and physical structure and space, security and data integrity
•    Monitoring SQL Server to minimize outages and troubleshooting to restore outages as they occur
•    Write database change scripts and deploy database change scripts including those from manufacturers and vendors 
•    Other duties as assigned.

Competencies, Knowledge, Skills and Abilities
•    Considerable working knowledge of and experience with SQL server database environment including:
o    Microsoft SQL Server 2012, 2016 Enterprise and Azure
o    SQL Server Management Studio
o    SSRS, SSIS and Report Builder
o    Data Extract, Transform and Load tools
o    T-SQL
•    Considerable working knowledge of operating system environments including:
o    Windows 2008/20012/2016
o    Linux OS – SUSE, RedHat
o    Shell scripting
•    Working knowledge or ability to learn the Oracle database environment
•    Working knowledge of Windows 2008, 2012 and 2016 Server operating environment
•    Maintenance of Database integrity and various interfaces
•    Enforcement of Quality Control and Database standards in the deployment and development of applications
•    Enforcement of information security policies
•    Management of the various SLAs (Service Level Agreements)
•    Knowledge of SQL recovery tools and utilities and SQL enterprise management tools and utilities
•    Proficiency in T-SQL and/or PL/SQL
•    Knowledge of JavaScript, JAVA, J2EE and XML
 

•    Completion of a bachelor’s degree program at an accredited college or university, which has included major course work in Computer Science, information science, systems analysis, software engineering, or a closely related field. 
•    A minimum of 7 years in database administration.

Please submit a resume and cover letter with your application. 

Successful candidate must be a City resident within six months of hire. 

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 or send an email to For more information, go to: Human Relations Website at: http://www.phila.gov/humanrelations