Company:
City of Philadelphia
Location: Philadelphia
Closing Date: 04/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Job Description
The Senior 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 general data management and SQL Server/PostgreSQL practice. This position reports to the IT Director of Data Management and receives guidance and direction from Database Administrators Leads.
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.
Understands, Implements, enforces, and monitors the 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.
Execute the established database operation 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. Tracks the provisioning process and reports to the team.
Participates in the database operation cost accounting and budgeting process.
Regularly communicates with the customer and address or escalate any identified dissatisfaction.
Shares technical knowledge with the team.
Tutors and coaches 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’, ‘Replication’ and auditing.
Operational knowledge of PostgreSQL (knowledge of Geometry data types a plus)
Familiarity with SQL Server Reporting Service (SSRS/PBIRS): Administration and Report Design
Operational Knowledge of another database management system used by the City (Oracle, Sybase, ADABAS, etc.) is a plus.
Experience with other cloud and open source database offerings is a plus: (MySQL, Aurora, Dynamo, MongoDB, MariaDB, Azure SQL Database, AWS RDS, etc.)
Operational Knowledge of TRANSACT-SQL and PL/pgSQL
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 the Powershell scripting language.
Knowledge of Data Warehousing Concepts is a plus.
Knowledge of Information Security Concepts: Identity and Access Management, etc.
Knowledge of Network Architecture concepts.
Operational knowledge of the WINDOWS operating system (2012 and up).
Experience with drawing system architecture diagrams.
Experience in implementing SSL encryption.
The Senior 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 general data management and SQL Server/PostgreSQL practice. This position reports to the IT Director of Data Management and receives guidance and direction from Database Administrators Leads.
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.
Understands, Implements, enforces, and monitors the 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.
Execute the established database operation 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. Tracks the provisioning process and reports to the team.
Participates in the database operation cost accounting and budgeting process.
Regularly communicates with the customer and address or escalate any identified dissatisfaction.
Shares technical knowledge with the team.
Tutors and coaches 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’, ‘Replication’ and auditing.
Operational knowledge of PostgreSQL (knowledge of Geometry data types a plus)
Familiarity with SQL Server Reporting Service (SSRS/PBIRS): Administration and Report Design
Operational Knowledge of another database management system used by the City (Oracle, Sybase, ADABAS, etc.) is a plus.
Experience with other cloud and open source database offerings is a plus: (MySQL, Aurora, Dynamo, MongoDB, MariaDB, Azure SQL Database, AWS RDS, etc.)
Operational Knowledge of TRANSACT-SQL and PL/pgSQL
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 the Powershell scripting language.
Knowledge of Data Warehousing Concepts is a plus.
Knowledge of Information Security Concepts: Identity and Access Management, etc.
Knowledge of Network Architecture concepts.
Operational knowledge of the WINDOWS operating system (2012 and up).
Experience with drawing system architecture diagrams.
Experience in implementing SSL encryption.
Share this job
Useful Links