Database Administrator

4 weeks ago


Philadelphia, United States Tri-Force Consulting Services, Inc. Full time
Job Description
Title: Database Administrator

Location: Philadelphia, PA

Duration: 12 Months

Client: City of Philadelphia

*** This is the onsite position from day one.

Job Description.

Statement of Work:

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.

Work activities:

  • 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.
Required:
  • At least 5 years of 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.


If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.

About Us:

Tri-Force is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 3 times(Ranked #931 2021) on Inc. 5000 fastest growing companies in the USA. Tri-Force Consulting Services, Inc. is an established consulting services firm offering innovative solutions to Government and Commercial sectors. We specialize in building customized software applications solutions such as knowledge management systems, business intelligence, data analysis, database support and maintenance, data warehouse implementation and support, systems architecture and systems integration for our clients. Our technical competencies are in Java, .NET, SharePoint, PHP, Business Intelligence (Cognos, Data Warehouse), mobile applications platforms (iPhone, iPad, Android, Blackberry), and various other technologies. We also specialize in providing resources to manage infrastructure projects. Tri-Force is one of the fastest growing companies in Philadelphia region by receiving the award 6 times and 4 times on Inc. 5000 fastest growing companies in the USA.

  • Philadelphia, United States Symmetrio Full time

    Symmetrio is actively recruiting for a Database Administrator for our customer, a large government organization in Philadelphia, PA. The Database Administrator will act as a supportive onsite role to the Platform Engineering team with a primary focus on performing highly technical SQL backend administration in two key areas: SQL systems (including...


  • Philadelphia, United States Symmetrio Full time

    Job DescriptionJob DescriptionSymmetrio is actively recruiting for a Database Administrator for our customer, a large government organization in Philadelphia, PA. The Database Administrator will act as a supportive onsite role to the Platform Engineering team with a primary focus on performing highly technical SQL backend administration in two key areas: SQL...


  • Philadelphia, United States JPC Partners Full time

    JPC Partners is looking for a DBA (Oracle / MS SQL) that will focus on database administration and engineering in a Linux, VMware and Windows server environments. Responsibilities: Day to day administration and maintenance of ORACLE databases 12c and 19 Monitoring and support of the ORACLE database infrastructure to ensure optimum performance,...


  • Philadelphia, Pennsylvania, United States Symmetrio Full time

    Symmetrio is actively recruiting for a Database Administrator for our customer, a large government organization in Philadelphia, PA. The Database Administrator will act as a supportive onsite role to the Platform Engineering team with a primary focus on performing highly technical SQL backend administration in two key areas: SQL systems (including...


  • Philadelphia, United States City of Philadelphia Pennsylvania Full time

    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 Database Administrator, SQL, Database, Administrator, Operations, Senior, Technology


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Management and Administration:Lead the management and administration of databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.Oversee database performance tuning and optimization...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Architecture and Design:Lead the design and architecture of complex database solutions, including database schemas, tables, views, and stored procedures, to meet business requirements and support application development initiatives.Collaborate with development teams to ensure optimal...


  • Philadelphia, United States GreenXT Full time

    GreenXT is seeking an **Oracle Database Administrator** to support their Navy customer. **About GreenXT** - GreenXT is comprised of technical and business leaders. We hire intelligent, hardworking, and dedicated people who not only possess the desire to learn and improve their skills but want to contribute to the design and development of innovative...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Maintenance:Assist in performing routine maintenance tasks such as backups, restores, and updates on databases.Learn and become familiar with database management systems (DBMS) and related tools used within the organization.Monitor database performance and assist in troubleshooting...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Management:Manage and administer databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.Monitor database performance and proactively identify and resolve performance issues,...


  • Philadelphia, Pennsylvania, United States City of Philadelphia Full time

    Job Description Position Summary: The Principal Database Administrator (PDA) is responsible for providing technical planning, design, implementation of initiatives as well as oversight of existing database instances and applications integration. This includes but is not limited to overseeing the development and organization of the databases, assessment and...


  • Philadelphia, Pennsylvania, United States City of Philadelphia Full time

    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...


  • Philadelphia, United States Berkshire Hathaway GUARD Insurance Companies Full time

    Overview Berkshire Hathaway GUARD offers a collaborative company culture with outstanding benefits and competitive compensation. Our organization hiring and we’re looking for talented individuals to join our team and establish a rewarding career with us. Our success is founded on our strong reputation, and we have received an A+ “Superior”...


  • Philadelphia, United States Central Association of the Miraculous Medal Full time

    JOB SUMMARY:Reporting to the Vice President, Institutional Advancement, the Database Manager will manage the Raisers Edge NXT and Raisers Edge Database View donor fundraising solutions. In conjunction with the CEO and VPs of all departments, the Database Manager will be responsible for database management and administration, including data integrity, all...


  • Philadelphia, United States Central Association of the Miraculous Medal Full time

    Reporting to the Vice President, Institutional Advancement, the Database Manager will manage the Raisers Edge NXT and Raisers Edge Database View donor fundraising solutions. In conjunction with the CEO and VPs of all departments, the Database Manager will be responsible for database management and administration, including data integrity, all reporting...


  • Philadelphia, Pennsylvania, United States Central Association of the Miraculous Medal Full time

    Reporting to the Vice President, Institutional Advancement, theDatabase Manager will manage the Raisers Edge NXT and Raisers EdgeDatabase View donor fundraising solutions. In conjunction with theCEO and VPs of all departments, the Database Manager will beresponsible for database management and administration, includingdata integrity, all reporting needs,...


  • Philadelphia, United States Central Association of the Miraculous Medal Full time

    Job DescriptionJob DescriptionJOB SUMMARY:Reporting to the Vice President, Institutional Advancement, the Raiser’s Edge Database Manager will manage the Raiser’s Edge NXT and Raiser’s Edge Database View donor fundraising solutions. In conjunction with the CEO and VPs of all departments, the Raiser’s Edge Database Manager will be responsible for...


  • Philadelphia, United States Neighbors Quality Health Care Full time

    **About Us**:Mental Health First Connects (MHFC) is committed to connecting individuals and communities with accessible mental health resources and support. Our mental health & wellness mission for Southeastern PA, is to decrease the stigma, break the silence, normalize mental wellness, provide mental health education, and increase a sustainable level of...


  • Philadelphia, United States Green and Spiegel U.S. Full time

    **KEY OBJECTIVE** The Bilingual Legal Administrative Assistant is responsible for providing administrative support to legal staff by performing clerical functions in both English and Spanish. Will provide full support to Case Coordinators, Case Managers, Supervising Attorneys, and Partners, assisting in daily office needs and general administrative...


  • Philadelphia, United States Green and Spiegel U.S. Full time

    Job DescriptionJob DescriptionSalary: Legal Administrative Assistant            KEY OBJECTIVE The Legal Administrative Assistant is responsible for providing administrative support to legal staff by performing clerical functions. Will provide full support to Case Coordinators, Case Managers, Supervising Attorneys, and Partners, assisting in daily...