Senior SQL Database Administrator

4 weeks 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 Server/PostgreSQL practice. This position reports to the IT Director of Data Management and receives guidance and direction from Database Administrators Leads.

Essential Functions

Provides hands-on operational support to the City’s mission critical databases.

Performs general Database Administration: DBMS software install, object management, startup and stoppage, patching and upgrade, etc.

Identifies performance issues and carries out Performance Tuning.

Participate in database software products evaluation.

Monitors database management systems (DBMS) and data reporting platforms across the Solution Deployment Life Cycle (Development, Test, Production) and insures that they perform within the expected service level.

Understands, Implements, enforces, and monitors the data security and compliance standards (NIST, HIPAA, CIJS, IRS PUB 1075, etc.)

Participates in the collection of database operations metrics for reports and capacity planning.

Execute the established database operation policies, procedures and processes.

Perform reliable backup and restore operations that meet the operations level requirements.

Provisions DBMS user access in accordance with the established data management procedures and policies.  Tracks the provisioning process and reports to the team.

Participates in the database operation cost accounting and budgeting process.

Regularly communicates with the customer and address or escalate any identified dissatisfaction.

Shares technical knowledge with the team.

Tutors and coaches junior team members.

Participates in the review and approval of software solution architectures.

Writes database and reporting systems operations automation scripts.

Performs various data management operations and configurations: Data ETL(extraction, transformation and load), data replication, data profiling, etc.

Create and maintain documentation on architecture, standards, and processes

Competencies, Knowledge, Skills and Abilities

Ability to:

Implement and operate enterprise class database management and reporting systems.

Understand and execute the architecture and design of database management system solutions.

Understand and execute data management and data security policies and procedures.

Write database and reporting systems operations automation scripts.

Work collaboratively

Work independently

Think systemically

Make presentations 

Knowledge Areas:

Full operational grasp of SQL Server, including ‘Always on’, ‘Replication’ and auditing.

Operational knowledge of PostgreSQL (knowledge of Geometry data types a plus)

Familiarity with SQL Server Reporting Service (SSRS/PBIRS): Administration and Report Design

Operational Knowledge of another database management system used by the City (Oracle, Sybase, ADABAS, etc.) is a plus.

Experience with other cloud and open source database offerings is a plus: (MySQL,  Aurora, Dynamo, MongoDB, MariaDB, Azure SQL Database, AWS RDS, etc.)

Operational Knowledge of  TRANSACT-SQL and PL/pgSQL

General Knowledge of Software Programming (mastery of a programming language is a plus).

Knowledge of ITSM/ITIL concepts and processes (Incident Management, Change Management, Problem Management, Release Management, etc.)

Working Knowledge of Microsoft Office Products: Visio, PowerPoint, Excel, Word

Knowledge of a database reporting software:  SSRS, Business Objects, Oracle BI, Power BI, etc.

Knowledge of the Powershell scripting language.

Knowledge of Data Warehousing Concepts is a plus.

Knowledge of Information Security Concepts: Identity and Access Management, etc.

Knowledge of Network Architecture concepts.

Operational knowledge of the WINDOWS operating system (2012 and up).

Experience with drawing system architecture diagrams.

Experience in implementing SSL encryption.

  • Senior Database Administrator

    3 days ago

    Philadelphia, United States Independence Blue Cross Full time

    Bring your drive for excellence, teamwork, and customer commitment to Independence. Join us as we renew and reimagine the future of health care. Together we will achieve our mission to enhance the health and well-being of the people and communities we serve. The position will work directly with various IT associates including Application Development, Server...

  • Senior-Level Database Administrator

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

  • Database Administrator

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

  • 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

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

  • Lead/Principal Database Administrator

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

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

  • Data Engineer II, Database Administrator

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

  • Mid-Level/Intermediate Database Administrator

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

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

  • Database Engineer

    6 days ago

    Philadelphia, United States FreedomPay Full time

    FreedomPay is currently seeking a senior Database Engineer with expertise in the Microsoft SQL Server and Snowflake. This is a full time salaried position, or initially contract to hire. You will join a team of world-class engineers and developers solving complex problems. You will be rewarded for creativity and innovation. In this role, you will be on top...

  • Database Admin

    5 hours ago

    Philadelphia, United States jobworX Full time

    **Job description** **TO HAVE YOUR APPLICATION PRIORITIZED USE THE LINK BELOW**: **TO HAVE YOUR APPLICATION PRIORITIZED USE THE LINK BELOW**: Minimum Required Knowledge & Experience - Bachelor’s Degree in computer science or software engineering from an accredited college or university or equivalent work experience. - 4 or more years administering SQL...

  • Oracle Database Administrator

    1 month ago

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

  • SQL Developer

    2 weeks ago

    Philadelphia, United States Berkshire Hathaway GUARD Insurance Companies Full time

    Overview Berkshire Hathaway GUARD Insurance Companies is looking for a SQL developer.  We are looking to fill this position in our Wilkes-Barre, PA, Philadelphia, PA or Parsippany, NJ Offices.  Berkshire Hathaway GUARD offers a collaborative company culture with outstanding benefits and competitive compensation. Our organization is hiring and we’re...

  • Senior Manager of Data Solutions Engineering

    1 month ago

    Philadelphia, United States Holland & Knight LLP Full time

    Description : The Senior Manager of Data Solutions Engineering is responsible for the development and management of the Firm’s data warehouse / lakehouse, data analytics platforms, and related processes. This role contributes to the implementation and on-going support of the firm’s cloud data systems and analytics tools and processes. The Senior...

  • Robotics Process Automation

    2 months ago

    Philadelphia, United States Motion Recruitment Full time

    Our client is a wealth management firm located in Center City Philadelphia and looking for an RPA Analyst. In this role, you will leverage your expertise in Robotics Process Automation (RPA), specifically with Automation Anywhere and Xceptor, as well as your knowledge of data warehousing and MS SQL. Your responsibilities will include collaborating with...

  • Data Warehouse Administrator

    1 week 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

    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

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

  • Data Warehouse Administrator

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