Senior SQL Database Administrator

About the position

The Senior SQL Server Database Administrator is a full-performance technologist responsible for providing operational database management services to the City of Philadelphia. This role involves implementing and maintaining the standards of the Office of Innovation & Technology (OIT) for SQL Server and PostgreSQL databases, ensuring data security, performance tuning, and operational support for mission-critical databases.

Responsibilities

• Provides hands-on operational support to the City's mission critical databases.
• Performs general Database Administration tasks including DBMS software installation, object management, startup and stoppage, patching, and upgrades.
• Identifies performance issues and carries out performance tuning.
• Participates in database software products evaluation.
• Monitors database management systems (DBMS) and data reporting platforms across the Solution Deployment Life Cycle (Development, Test, Production).
• Understands, implements, enforces, and monitors data security and compliance standards (NIST, HIPAA, CIJS, IRS PUB 1075, etc.).
• Participates in the collection of database operations metrics for reports and capacity planning.
• Executes established database operation policies, procedures, and processes.
• Performs reliable backup and restore operations that meet operational level requirements.
• Provisions DBMS user access in accordance with established data management procedures and policies.
• Participates in the database operation cost accounting and budgeting process.
• Regularly communicates with customers and addresses or escalates any identified dissatisfaction.
• Shares technical knowledge with the team and tutors 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 including Data ETL, data replication, and data profiling.
• Creates and maintains documentation on architecture, standards, and processes.

Requirements

• Bachelor's Degree in computer science, mathematics, business, or equivalent.
• 5 years of information technology experience including extensive database administration in SQL Server and PostgreSQL.
• Full operational grasp of SQL Server, including ‘Always on', ‘Replication', and auditing.
• Operational knowledge of PostgreSQL.
• Familiarity with SQL Server Reporting Service (SSRS/PBIRS).
• Operational knowledge of another database management system (Oracle, Sybase, ADABAS, etc.) is a plus.
• Experience with cloud and open source database offerings (MySQL, Aurora, Dynamo, MongoDB, etc.) is a plus.
• Operational knowledge of TRANSACT-SQL and PL/pgSQL.
• General knowledge of software programming is a plus.
• Knowledge of ITSM/ITIL concepts and processes.

Nice-to-haves

• Database Administration Certification is a plus.
• Knowledge of Data Warehousing Concepts is a plus.
• Knowledge of Information Security Concepts: Identity and Access Management, etc.
• Knowledge of Network Architecture concepts.

Benefits

• Comprehensive health coverage for employees and their eligible dependents.
• Wellness program offering eligibility into the discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.
• Eligibility for the Public Service Loan Forgiveness program.
• Free Commute on SEPTA with the Key Advantage Program.
• Tuition discounts and scholarships with partnerships from local colleges and universities.