Database Administrator

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

  • Database Administrator

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

  • Database Administrator

    2 days ago

    Philadelphia, United States FreedomPay Full time

    The FreedomPay Commerce Platform is the technology of choice for many of the largest companies across the globe in retail, hospitality, lodging, gaming, sports and entertainment, foodservice, education, healthcare and financial services. FreedomPay's technology has been purposely built to deliver rock solid performance in the highly complex environment of...

  • Senior-Level Database Administrator

    4 weeks ago

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

  • Lead/Principal Database Administrator

    4 weeks ago

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

  • Entry-Level/Junior Database Administrator

    4 weeks ago

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

  • Mid-Level/Intermediate Database Administrator

    4 weeks ago

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

  • Database Administrator/Systems Integrator

    1 month ago

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

  • Data Engineer II, Database Administrator

    6 days ago

    Philadelphia, United States JPMorgan Chase Full time

    Job Description You thrive on diversity and creativity, and we welcome individuals who share our vision of making a lasting impact. Your unique combination of design thinking and experience will help us achieve new heights.As a Data Engineer II, Database Administrator (SQL/AWS DBA) at JPMorgan Chase within the Community and Investment Banking team, you are...

  • Raisers Edge Database Manager

    1 month ago

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

  • Raisers Edge Database Manager

    1 month ago

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

  • Raiser's Edge Database Manager

    4 weeks ago

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

  • Administrative Assistant

    1 week ago

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

  • Data Warehouse Administrator

    1 day ago

    Philadelphia, United States American Heritage Credit Union Full time

    Job DescriptionJob DescriptionAmerican Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries...

  • Data Warehouse Administrator

    2 days ago

    Philadelphia, United States American Heritage Federal Credit Union Full time

    American Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries and reports. Add additional data...

  • Office Administrator

    5 days ago

    Philadelphia, United States National Disease Research Interchange Full time

    The Office Administrator will report directly to the Chief Financial Officer, V.P., Administration. He/she’s primary responsibility is to act as the first point of contact for the President/CEO with internal and external clients and to provide support in a one-on-one working relationship. Additionally, he/she will be responsible for various duties for the...

  • Marketing Administrator

    23 hours ago

    Philadelphia, United States United Refrigeration Full time

    About the Role: The marketing administrator role with United Refrigeration is a full time position operating out of URIs corporate HQ in North East Philadelphia. Core Responsibilities of a Marketing Administrator: Work with stores and product managers to create event flyers for training and counter days Develop layouts for ads, training manuals,...

  • Marketing Administrator

    10 hours ago

    Philadelphia, United States United Refrigeration, Inc. Full time

    About the Role: The marketing administrator role with United Refrigeration is a full time position operating out of URI’s corporate HQ in North East Philadelphia. Core Responsibilities of a Marketing Administrator:Work with stores and product managers to create event flyers for training and counter daysDevelop layouts for ads, training manuals,...

  • Marketing Administrator

    2 days ago

    Philadelphia, United States United Refrigeration, Inc. Full time

    About the Role: The marketing administrator role with United Refrigeration is a full time position operating out of URI’s corporate HQ in North East Philadelphia. Core Responsibilities of a Marketing Administrator:Work with stores and product managers to create event flyers for training and counter daysDevelop layouts for ads, training manuals,...

  • Temporary Administrative Assistant

    1 day ago

    Philadelphia, Pennsylvania, United States Michael Page Full time

    About Our Client Construction | Manufacturing | Industrial Job Description Provide general administrative support to the construction team, including filing, data entry, photocopying, and scanning documents.Assist in the preparation of project proposals, bids, and contracts.Manage incoming and outgoing correspondence, including emails, phone calls, and...

  • NetSuite Administrator

    8 hours ago

    Philadelphia, United States Sparks Full time

    Position Overview: The NetSuite Administrator will play an important foundational role in the implementation of new business processes that will be done through the NetSuite ecosystem. This position will be responsible for providing training and support for all NetSuite users, as well as other NetSuite administrative tasks. Responsibilities: * Tier 1...