SQL Database Administrator (Airport) Job at City of Philadelphia
A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.
What We Offer:
Impact - The work you do here matters to millions.
Growth - Philadelphia is growing, why not grow with it?
Diversity & Inclusion - Find a career in a place where everyone belongs.
Benefits - We care about your well-being.
The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). 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. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city’s technology assets and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.
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.
- 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.
- Considerable working knowledge of, and hands-on experience with, SQL server and Azure database environments including:
o Redshift
o Microsoft SQL Server 2012, 2016, 2019 Enterprise and Azure
o Installing, Configuring, maintaining, and securing SQL Server databases on-premises environment
o Configuring and Managing AlwaysOn Availability Group
o Database migration and SQL Server patching
o Database Modeling and physical Implementation of logical models
o Working with application developers in helping with their data need and schema modification
o Provisioning Azure resources such as SQL Instance, Database, Storage and creating database objects
o Designing Azure data factory pipelines to synchronize data in different environments
o Manage azure databases and object permissions
o Configuring Azure SQL Auto-Failover groups
o Third-party monitoring tools, preferably Redgate
o Knowledge of Data Lake analytics is a plus
o SQL Server Management Studio and Visual 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 AWS
o Windows
o Linux OS – SUSE, RedHat
o Shell scripting
- Working knowledge or ability to learn the Oracle database environment
- Working knowledge of Windows 2008, 2012, 2016 and 2019 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 C#, 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.
Additional Information
Salary Range: $90,000 - $100,000
Starting salary to be determined based on experience and qualifications.
Important: To apply, candidates must provide a cover letter and a resume.
- We are a Public Service Loan Forgiveness Program qualified employer
- 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
- We offer Comprehensive health coverage for employees and their eligible dependents
- Our wellness program offers eligibility into the discounted medical plan
- Employees receive paid vacation, sick leave, and holidays
- Generous retirement savings options are available
The successful candidate must be a city of Philadelphia resident within six months of hire.
Please note that effective September 1, 2021, the City of Philadelphia is requiring all new employees to present proof of vaccination against COVID-19.
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 faqpchr @phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx
Please Note :
caminobluff.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, caminobluff.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.