Current Openings
Database Administrator
Current Openings, Phila, Pennsylvania, United States, 19117
A Pennsylvania state agency located in Philadelphia, PA is looking for a Database Administrator for a 12 month contract.
Please note that this position requires onsite work
Pay rate range: $63.00/hr - $72.00/hr
Required SkillsAt least 5 years of experience in administration and management of database platforms and application backend infrastructureExpertise in MS SQL Server platform and modules, including SSRS/PBIRS, 'Always on' clusters, 'Replication', and 'Auditing'Working knowledge of Oracle platforms and products including DataguardStrong understanding of alternative SQL platforms and products including PostgreSQL, Sybase, AzureDB, and MariaDB, Business Objects, Power BI, or similarWorking knowledge of Data Warehousing concepts • Firm grasp on IT network architecture and server operating systems (Windows Server and Linux)Ability to carry out administrative and technical communication orally and in writingStrong documentation and presentation skills of data concepts and modelsKnowledge of ITSM/ITIL concepts and processes (Incident Management, Change Management, Problem Management, Release Management, etc.)Knowledge of Information Security Concepts: Identity and Access Management, etc.Ability to work independently and engage in self-learningPreferred Skills
Understanding for programming concepts/languages is a strong plusKnowledge of the zOS Mainframe concepts is a strong plusAny certifications in database administration or data warehousing is a strong plusResponsibilities
The ideal candidate will act as a supportive onsite role to the PPD Platform Engineering team with primary focus for performing highly technical SQL backend administration in two focus areas: In SQL systems (including Application, Database, Network, and Server) and SQL security (including CJIS/Cyber Security and Access Control).They will be responsible for installing, maintaining, and administering databases and SQL instances, ensuring that they are secure, consistent, and operational.It is expected that all work will be performed within a framework of industry standards, best practices, and strategic IT principles and policy guidelines.As a public safety law enforcement environment, this individual will be expected to take proactive steps to manage database performance and optimization across SQL environments for uptime consistency as well as develop comprehensive backup/restoration models for application databases.In addition, the individual will also be expected to adhere to change/problem and incident management processes.Provide database administration services (e.g., script and instance creation, modeling, modification, copying schemas, tables, views, indexes, stored procedures, triggers, and integrity constraints for moderate to complex issues and systems (e.g., production, non-production, and replication servers)Document, implement, maintain, and support deployment and monitoring of moderate to complex database systemsPlan and conduct database system tests and implement corrective actions to ensure all database servers meet or exceed documented service levelsConfigure and customize moderate to complex search features, queries, and solutionsCreate, manage, modify, and/or convert SQL reports, extracts, or ETLsParticipate in assigned application projects as a member, but may function as a leadRecommend, document, and communicate administration best practices for data integrityConduct periodic software audits of database products for compliance with standard policies and procedures.Identify new initiatives and recommendations for database growth and integrationMonitor database performance metrics to implement tuning and improvementsDesign, implement, and validate data backup, archive, and recovery workflowsPerform additional duties of Database Administrator as required
Please note that this position requires onsite work
Pay rate range: $63.00/hr - $72.00/hr
Required SkillsAt least 5 years of experience in administration and management of database platforms and application backend infrastructureExpertise in MS SQL Server platform and modules, including SSRS/PBIRS, 'Always on' clusters, 'Replication', and 'Auditing'Working knowledge of Oracle platforms and products including DataguardStrong understanding of alternative SQL platforms and products including PostgreSQL, Sybase, AzureDB, and MariaDB, Business Objects, Power BI, or similarWorking knowledge of Data Warehousing concepts • Firm grasp on IT network architecture and server operating systems (Windows Server and Linux)Ability to carry out administrative and technical communication orally and in writingStrong documentation and presentation skills of data concepts and modelsKnowledge of ITSM/ITIL concepts and processes (Incident Management, Change Management, Problem Management, Release Management, etc.)Knowledge of Information Security Concepts: Identity and Access Management, etc.Ability to work independently and engage in self-learningPreferred Skills
Understanding for programming concepts/languages is a strong plusKnowledge of the zOS Mainframe concepts is a strong plusAny certifications in database administration or data warehousing is a strong plusResponsibilities
The ideal candidate will act as a supportive onsite role to the PPD Platform Engineering team with primary focus for performing highly technical SQL backend administration in two focus areas: In SQL systems (including Application, Database, Network, and Server) and SQL security (including CJIS/Cyber Security and Access Control).They will be responsible for installing, maintaining, and administering databases and SQL instances, ensuring that they are secure, consistent, and operational.It is expected that all work will be performed within a framework of industry standards, best practices, and strategic IT principles and policy guidelines.As a public safety law enforcement environment, this individual will be expected to take proactive steps to manage database performance and optimization across SQL environments for uptime consistency as well as develop comprehensive backup/restoration models for application databases.In addition, the individual will also be expected to adhere to change/problem and incident management processes.Provide database administration services (e.g., script and instance creation, modeling, modification, copying schemas, tables, views, indexes, stored procedures, triggers, and integrity constraints for moderate to complex issues and systems (e.g., production, non-production, and replication servers)Document, implement, maintain, and support deployment and monitoring of moderate to complex database systemsPlan and conduct database system tests and implement corrective actions to ensure all database servers meet or exceed documented service levelsConfigure and customize moderate to complex search features, queries, and solutionsCreate, manage, modify, and/or convert SQL reports, extracts, or ETLsParticipate in assigned application projects as a member, but may function as a leadRecommend, document, and communicate administration best practices for data integrityConduct periodic software audits of database products for compliance with standard policies and procedures.Identify new initiatives and recommendations for database growth and integrationMonitor database performance metrics to implement tuning and improvementsDesign, implement, and validate data backup, archive, and recovery workflowsPerform additional duties of Database Administrator as required