Database Administrator

Philadelphia, PA 19019

Posted: 03/14/2024 Job Category: Database Administrator Job Number: 1905

Job Description

Database Administrator Opportunity For Your Consideration

Become a member of a growing team of Information Technology professionals making an impact and providing solutions throughout Pennsylvania – Join the Domino Tech Team!

The Position:
Client: City of Philadelphia – Office of Innovation and Technology
Position Title: Database Administrator
Location: On-Site in Philadelphia, PA
Duration: 12+ Month Project

*Respond Right Away, Accepting Candidates and Actively Interviewing Until Filled

The resource will support areas of SQL backend infrastructure including configuration, management, and performance of databases for in-house applications managed or owned by the Philadelphia Police Department.  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 systems
- Plan and conduct database system tests and implement corrective actions to ensure all database servers meet or exceed documented service levels
- Configure and customize moderate to complex search features, queries, and solutions
- Create, manage, modify, and/or convert SQL reports, extracts, or ETLs
- Participate in assigned application projects as a member, but may function as a lead
- Recommend, document, and communicate administration best practices for data integrity
- Conduct periodic software audits of database products for compliance with standard policies and procedures
- Identify new initiatives and recommendations for database growth and integration
- Monitor database performance metrics to implement tunning and improvements
- Design, implement, and validate data backup, archive, and recovery workflows
- Perform additional duties of a?Database Administrator?as required

The Preferred Skills and Experience:
- 5+ Years: Experience in administration and management of database platforms and application backend infrastructure
- Expertise in MS SQL Server platform and modules, including SSRS/PBIRS, ‘Always on’ clusters, ‘Replication’, and ‘Auditing’
- Working knowledge of Oracle platforms and products including Dataguard
- Strong understanding of alternative SQL platforms and products including PostgreSQL, Sybase, AzureDB, and MariaDB, Business Objects, Power BI, or similar
- Working 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 writing
- Strong documentation and presentation skills of data concepts and models
- Knowledge 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-learning
- Understanding for programming concepts/languages is a strong plus
- Knowledge of the zOS Mainframe concepts is a strong plus
- Any certifications in database administration or data warehousing is a strong plus

The Company:
The mission of Domino Technologies, Inc. is to provide clients with IT solutions for their individual business processes that lead to strategic market advantages.  Since its founding in 1996, the Domino Tech Team has built a solid record of performance working with clients in the Government and Commercial sectors.

The Perks:
- Excellent Market Salary
- Competitive Benefits
- Paid Holidays and Vacation
- Positive Work-Life Balance

The Location:
Domino Technologies is based in the Harrisburg area – the capital city of the Commonwealth of Pennsylvania and the county seat of Dauphin County.  Located on the east bank of the Susquehanna River, Harrisburg is the anchor of the Susquehanna Valley metropolitan area.

Contact Us Today!
 

Meet Your Recruiter

Roy Myers
Vice President, Operations

Roy has over 30 years of experience in the Information Technology field. Roy joined Domino Technologies in 2007 and is responsible for account management and client/employee relations. Roy’s focus has been building a strong Company reputation and recruiting a team to service Domino’s growth. Roy’s vast experience within the IT industry includes expertise in recruiting, account management, mentoring, and business development.

Roy enjoys numerous outdoor activities, cooking, and spending time with family and friends.

 

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Philadelphia, PA

Ready to embark on a new career adventure in the vibrant city of Philadelphia, Pennsylvania? Explore our job opportunities in the City of Brotherly Love and discover the countless growth possibilities this historic region offers aspiring professionals. From iconic landmarks like the Liberty Bell and Independence Hall to the mouthwatering Philly cheesesteaks and world-class art galleries such as The Barnes Foundation, Philadelphia is a treasure trove of culture and charm. With renowned theaters like the Walnut Street Theatre, professional sports teams like the Eagles and Phillies, and gorgeous outdoor spaces like Fairmount Park, Philadelphia has something for everyone. Don't miss out on the chance to make your mark in this dynamic city — browse our job listings now and take the first step towards your dream career!