Baltimore County - Towson, MD

posted about 2 months ago

Full-time - Mid Level
Towson, MD
Repair and Maintenance

About the position

The Database Administrator position in the Office of Information Technology is a part-time role that requires a strong background in database management and administration. Under general supervision, the individual will support enterprise database systems and activities, which include database design, development, maintenance, backup and recovery, modeling, integration, documentation, and tuning. The role involves overseeing and managing activities related to enterprise database systems, including the installation of enterprise database software and management of enterprise database servers. The Database Administrator will be responsible for installing, upgrading, and patching supported database systems, ensuring that database system availability meets the agreed-upon service level agreements. This includes performance tuning, capacity planning, code review, and troubleshooting. The individual will also develop, document, and implement processes for the backup, recovery, and maintenance of database systems, adhering to Baltimore County's data retention policies. In addition, the role requires the development and implementation of database security measures, disaster recovery procedures, and standard database administration procedures and policies. The Database Administrator will conduct knowledge-sharing sessions with other technical development members and maintain regular communication with management regarding project status, potential risks, and needs. Continuous professional development through workshops and classes is also expected to keep skills current in this fast-paced environment.

Responsibilities

  • Support enterprise database systems and activities including database design, development, maintenance, backup and recovery, modeling, integration, documentation, and tuning.
  • Oversee and manage activities related to enterprise database systems including the installation of enterprise database software and management of enterprise database servers.
  • Install, upgrade, and patch supported database systems.
  • Manage database system availability for applications and customers, ensuring databases maintain agreed upon service level agreements.
  • Develop, document, and implement processes for backup, recovery, and maintenance of database systems as defined by service level agreements.
  • Develop, test, document, and maintain database security and system security as defined by service level agreements.
  • Develop, test, and implement database capacity planning, performance, and monitoring scripts/processes for assigned databases and applications.
  • Develop and implement disaster recovery procedures for multiple database systems in High Availability (HA)/Disaster Recovery (DR) environments.
  • Administer and support 24x7 production environments along with support of development/test databases related to OLTP/DSS, and E-Commerce.
  • Conduct knowledge sharing sessions with other technical development members in the organization.

Requirements

  • Possession of a bachelor's degree preferred, plus five years progressive experience with database administration, data modeling, data architecture and database technologies.
  • Proficiency with operating system command language is required.
  • Experience with SQL Server 2012-2021, experience with Oracle is a plus.
  • Knowledge of Cloud Database Technologies and Data Warehouse concepts and integrations.
  • Experience with integration tools such as SharePoint, ADO, SSRS/SSIS/SSAS, and Power BI.
  • Proficiency in scripting languages (e.g., Python, Perl, SQL, PL/SQL, T-SQL, R, PowerShell).
  • Experience with Active Directory Integration and Azure/Cloud integrations for security.
  • Knowledge of virtualization technologies for RDBMS systems.
  • Experience implementing High Availability (HA) and Disaster Recovery (DR) options for RDBMS systems.

Nice-to-haves

  • Experience with third-party DBA tools and applications.
  • Basic knowledge of a Systems Development Methodology, Agile.
  • Ability to work closely with System Administrators, Application Developers, DBA's, Data Architects, Product Managers, and Project Managers.

Benefits

  • Paid holidays
  • Health insurance
  • Dental insurance
  • Flexible spending account
  • Employee assistance program
  • Vision insurance
  • Life insurance
  • Retirement plan
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service