Principal Database Administrator

2 weeks ago

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 implementation of new integrations, and providing the GIS Team and PhillyStat360 with a long-term perspective on the relationship of database technology to the business needs facing the City.

This role is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment and data warehouse that meets current and future business objectives. In addition, this position is responsible for working closely with the Chief Counsel/Director and their First Deputy to support implementation of processes and systems to maximize employee and City-wide performance on quality-of-life issues in an environment that promotes positive morale, equity, diversity and inclusion.

Essential Functions:

Trains, mentors and develops subordinate technical support and applications staff to better utilize on-line processing databases environment.

Identifies and provides and designs tools to assist in the management of the database and transaction processing environment.

Works to provide a working model of our transaction processing environment for capacity assessment and planning.

Acts as primary liaison between employees to implement Office initiatives, policies, practices, and procedures as well as trouble shooting issues as they arise.

Develops a methodology for the ongoing assessment of database performance and the identification of problem areas.

Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary.

Provides leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications.

Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments.

Work with OIT to build the logical database area and provide technical guidance during all phases of the development process.

Works with vendors in evaluating and implementing new technologies.

During the capital project implementation process, the position is expected to: own, track and resolve database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems that ensure the most efficient and effective capital project solutions.

Establish and maintain communication with technology customers to keep them updated with status of their capital project related requests

Initiate changes on developing the capital projects production systems and proactively escalating any issues that cannot be resolved within the established timeframes.

Own the technical engagement (design and build) and ultimate success around specific implementation projects.

Provide subject matter expertise for the conversion and migration efforts from beginning to end.

Provide end-to-end root cause analysis and assistance for issues related to databases.

Gain a deep application-level knowledge of the systems assigned as well as contributing to their overall design.

Work closely with other internal teams to build security, reliability, and scalability into the database · architecture.

Provide sizing and recommended configurations for new database requests.

Participation on project teams.

Develop and improve operational procedures and maintain documentation.

Monitor availability and performance of all databases and related applications assigned.

Close Helpdesk tickets for incidents and requests.

Administer vendor support and maintenance contracts where appropriate.

Provide level 3 systems troubleshooting & problem resolution for internal and external customers.

Work some non-standard work hours and participate in off-hours call rotation.

Other duties as assigned.

Required Competencies, Knowledge, Skills, and Abilities:

Knowledge:

Database Security

Relational Database Management System (RDBMS)

SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system stored procedures)

Windows server, security delegation, SPNs, storage components

IT security risks

Backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication

Indexes, index management, integrity checks, configuration, patching

Statistics, index storage, creation, and management

Logical and physical database design and metadata

3rd party DBA tools and applications (e.g., redgate, idera, SCOM, Erwin)

Scripting languages like Powershell, VBScript, WSH

DB reporting and query tools and practices

Skills:

Ability to analyze customer needs, document, and design technical solutions

Technical documentation skills

SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)

Documentation skills for processes and procedures (creating KBs, runbooks, topology, etc.)

Building highly-available and fault-tolerant enterprise database solutions

Strong troubleshooting skills

Strong written and verbal communication skills

Organizational and project management skills

Abilities:

Ability to present ideas in user-friendly language

Self-motivated and directed, with keen attention to detail

Able to prioritize and execute tasks in a high-pressure environment

SQL Database Operational support to tech users Sharp technical, analytical, and problem-solving abilities

Expert technical knowledge of Database structures and designs

Experience working in a technical advisory design and deployment role

Experience with physical and virtual server, storage, and networking

Demonstrated technical leadership and team-building abilities

Accountability and ownership of systems/processes

Strong customer service, communications, and professional demeanor

Organized; able to manage multiple deadlines

Positive, resourceful, creative, and detail-oriented

Ability to work independently, a self-starter, able to prioritize appropriately

Reliability, honesty, and integrity

  • Database Administrator

    3 weeks ago

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

  • Lead/Principal Database Administrator

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

  • Senior SQL Database Administrator

    1 week ago

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

  • Database Administrator

    2 weeks ago

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

  • Database Administrator

    2 days ago

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

  • Database Administrator

    1 month ago

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

  • Database Administrator

    2 weeks ago

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

  • Database Administrator

    2 days ago

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

  • Database Administrator

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

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

  • Database Administrator

    5 days ago

    Philadelphia, United States Absolute Staffing & Consulting Solutions Full time

    Absolute Staffing is searching for a Database Administrator to work with our client.  Location: Albany, NY (12207) Duration: 24 Months Job Description: 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. 84 months of Experience designing and...

  • Senior SQL Database Administrator

    3 days ago

    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

  • Senior-Level Database Administrator

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

  • Entry-Level/Junior Database Administrator

    2 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

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

  • Assistant Principal

    2 weeks ago

    Philadelphia, United States Archdiocese of Philadelphia Full time

    Job DescriptionJob DescriptionPLEASE NOTE: FOR THIS POSITION YOU SHOULD NOT APPLY VIA THIS SYTEM BUT RATHER SUBMIT YOUR RESUME DIRECTLY TO THE PARISH OR AGENCY AS LISTED BELOW ON THIS POSTING (HIGHLIGHTED IN RED), OTHERWISE YOUR APPLICATION MAY NOT BE SUBMITTED TO THE APPROPRIATE PARTY. THANK YOU.Job Title: Assistant PrincipalJob Status: Permanent/Full...

  • Assistant Principal

    2 weeks ago

    Philadelphia, United States Archdiocese of Philadelphia Full time

    Job DescriptionJob DescriptionPLEASE NOTE: FOR THIS POSITION YOU SHOULD NOT APPLY VIA THIS SYTEM BUT RATHER SUBMIT YOUR RESUME DIRECTLY TO THE PARISH OR AGENCY AS LISTED AT THE BOTTOM OF THIS POSTING (HIGHLIGHTED IN RED), OTHERWISE YOUR APPLICATION MAY NOT BE SUBMITTED TO THE APPROPRIATE PARTY. THANK YOU.Assistant PrincipalContact: Sister Joseph Marie...

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

  • Principal

    4 weeks ago

    Philadelphia, United States Russell Byers Charter School Full time

    **Job Title: K-8 Principal** **Position Overview**: The K-8 Principal serves as the instructional leader and administrative head of the school, responsible for providing visionary leadership, fostering a positive school culture, and ensuring high levels of academic achievement for all students. The Principal is accountable for the overall operation and...

  • Administrative Assistant

    3 weeks ago

    Philadelphia, United States Archdiocese of Philadelphia Full time

    Job DescriptionJob DescriptionPLEASE NOTE: FOR THIS POSITION YOU SHOULD NOT APPLY VIA THIS SYTEM BUT RATHER SUBMIT YOUR RESUME DIRECTLY TO THE PARISH OR AGENCY AS LISTED AT THE BOTTOM OF THIS POSTING (HIGHLIGHTED IN RED), OTHERWISE YOUR APPLICATION MAY NOT BE SUBMITTED TO THE APPROPRIATE PARTY. THANK YOU.Job Title: Administrative AssistantJob Status:...