General Descriptions
The role of the Database Administrator with Enterprise Technology Services is to:
- Work at a high level to facilitate effective database services with a diverse group of technical and customer stakeholders toward optimal business goals.
- Lead teams and works independently (within a team) at a high level and often critical time frame(s) to resolve Project objectives and Production Support related to SQL databases / Applications.
- Provide database administration managing medium and large-sized production database systems across multiple environments including MS SQL Server 2017, 2019 and 2022 on Windows Servers and Oracle databases on Windows and Linux Servers.
- Independently provide decision making in support of best practice database administration.
• Provides in-depth knowledge and experience implementing High Availability Disaster Recovery solutions including Log Shipping, Transactional Replication, Microsoft Windows Clustering, and SQL Always on Availability Groups.• Analyzes and Designs Data Driven Business solutions for agency customers. Works with Technical Team Members (and vendors) to Implement new Software Solutions per Vendor specifications.
- Creates and implements capacity plans that include but are not limited to: SAN storage, drive optimizations, and CPU/memory management, and life-cycle management.
- Develops and Implements Backup and Recovery plans, scheduling backups, monitoring failed/completed Jobs, and validating database restores. Conducts Disaster Recovery (DR) Failover Testing validation.
- Develops and Maintains Technical Standards and Procedures including Best Practices and maintains Database Process Flow and related support Diagrams / Documentation.
- Installs, Configures, Patches, Tests and Upgrades Microsoft SQL Server and Oracle database software.
- Recommends and provides solutions to vendor (and County built) application issues and business problems.
Minimum Requirements:
Associate's degree or higher in business analysis, information technology, software engineering or related field.
(One year of relevant experience may be substituted for each year of required education.)
Minimum two years prior experience in database fundamentals (configuring data access and auditing, back-up/restoration, monitoring, high availability/disaster recovery, storage and daily managing of multiple database versions and related servers as well as a broad understanding of software development, server administration, networking and IT security.
Preferences:
- Relevant Bachelor's or Master's Degree in Computer Science or related field
- Experience with interface development and deployment to/from multiple systems
- Microsoft Certified Solutions Associate (MCSA): SQL Database Administration / Oracle Database Administration Certification
- Three or more years of experience of hands-on Microsoft SQL Server and/or Oracle Database Administration experience
The functions listed below are those that represent the majority of the time spent working in this class. Management may assign additional functions related to the type of work of the job, as necessary.
Administer Microsoft SQL Server and/or Oracle databases in medium and large-sized production and non-production systems across multiple environments including Windows. Linux and UNIX Servers.
Provide independent decision making, troubleshooting and problem solving in support of best practice database administration and promotion of business application efficiency and data security.
Develop, maintain and adhere to standards and database administration procedures including best practices and maintaining database process flow and related support diagrams. Install, Configure, Patch, Tune, Test and Upgrade SQL Server and/or Oracle software.
Analyze and design data driven business solutions for agency customers. Work with ETS Technical Team Members (and vendors), and customers to implement new software solutions.
Independently evaluate and resolve database issues including troubleshooting CPU, memory, I/O and other issues as well as analyzing the underlying servers for problems. Proactively conduct Performance monitoring, tuning and database optimizations.
Implement high availability disaster recovery solutions including Log Shipping, Transactional Replication, Microsoft Windows Clustering, SQL Always on Availability Groups.
Manage and troubleshoot database security, auditing, encryption, network segmentations and firewall/appliance rules for all environments to ensure security and compliance
Implement and support databases in Azure, AWS, OCI or similar cloud Infrastructure environments.
Install and manage Power BI Reporting Services (PBIRS) , SQL Reporting Services (SSRS), SQL Analysis Services (SSAS), and Integration Services (SSIS).
Install Oracle database software and architect related databases. Create storage database structures with high-level security features. Conduct performance tuning of the databases for optimal efficiency. Maintain High Availability production database environments using Oracle Data Guard.
May manage and mentor other DBA project team members as the DBA subject matter expert.
Performs related work as assigned.
Physical Demands
Physical demands refer to the requirements for physical exertion and coordination of limb and body movement.
Performs light work that involves walking or standing most of the time and involves exerting up to 20 pounds of force on a regular and recurring basis, or skill, adeptness and speed in the use of fingers, hands or limbs on repetitive operation of mechanical or electronic office equipment within moderate tolerances or limits of accuracy.
Unavoidable Hazards (Work Environment)
Unavoidable hazards refer to the job conditions that may lead to injury or health hazards even though precautions have been taken.
Competencies
Anticipates and adopts innovations in business-building digital and technology applications. Is an early adopter of new technologies, technical skills, and capabilities that improve performance. Regularly experiments with and leverages technologies and tools to substantially improve performance.
Makes sense of complex, high quantity, and sometimes contradictory information to effectively solve problems. Looks at complex issues from multiple angles; explores issues to uncover underlying issues and root causes; sees the main consequences and implications of different options.
Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm. Takes timely action on important or difficult issues. Identifies and pursues new opportunities that benefit the organization.
Plans and prioritizes work to meet commitments aligned with organizational goals. Stays focused on plans and improvises in response to changes, including risks and contingencies. Aligns own team's work with other workgroups'. Looks ahead to determine and obtain needed resources to complete plans.
Knows the most effective and efficient processes to get things done, with a focus on continuous improvement. Pays close attention to a variety of metrics and benchmarks; determines both major and subtle ways to optimize processes. Swiftly resolves process breakdowns; takes steps to ensure that problems do not recur.
Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences. Disseminates knowledge, insights, and updates in a polished, precise, and compelling manner. Demonstrates a deep interest in others' comments. Creates rich documents and reports.
Actively seeks new ways to grow and be challenged using both formal and informal development channels. Demonstrates strong commitment to own development by continuously updating knowledge, skills, and abilities. Shows strong enthusiasm for seeking learning opportunities.
County Core Values
All Broward County employees strive to demonstrate the County's four core behavioral competencies.
-
Collaborates: Building partnerships and working collaboratively with others to meet shared objectives.
-
Customer focus: Building strong customer relationships and delivering customer-centric solutions.
-
Instills trust: Gaining the confidence and trust of others through honesty, integrity, and authenticity.
-
Values differences: Recognizing the value that different perspectives and cultures bring to an organization.
Americans with Disabilities Act (ADA) Compliance
Broward County is an Equal Opportunity Employer committed to inclusion. Broward County is committed to providing equal opportunity and reasonable accommodations to qualified persons with disabilities. We support the hiring of people with disabilities; therefore, if you require assistance due to a disability, please contact the Professional Standards Section in advance at 954-357-6500 or email
[email protected] to make an accommodation request.
Emergency Management Responsibilities
Note: During emergency conditions, all County employees are automatically considered emergency service workers. County employees are subject to being called to work in the event of a disaster, such as a hurricane, or other emergency situation and are expected to perform emergency service duties, as assigned.
County-wide Employee Responsibilities
All Broward County employees must serve the public and fellow employees with honesty and integrity in full accord with the letter and spirit of Broward County's Employee Code of Ethics, gift, and conflict of interest policies.
All Broward County employees must establish and maintain effective working relationships with the general public, co-workers, elected and appointed officials and members of diverse cultural and linguistic backgrounds, regardless of race, color, religion, sex, national origin, age, disability, marital status, political affiliation, familial status, sexual orientation, pregnancy, or gender identity and expression.
