SQL/Oracle DBA - Intermediate

Citizens is pleased to offer this opportunity on a remote / virtual basis (within USA)
Searching for a place to make your mark? Every great team depends on the individual contributions of its members – the skills, talents and the passion that each team member brings. At Citizens, we’re building a workforce of top achievers committed to our company’s mission and vision. Our company values the knowledge that comes from experienced and dedicated individuals with a variety of backgrounds, in or out of insurance.
Citizens’ Mission is to provide property insurance protection in Florida to those who are, in good faith, unable to obtain coverage through the private market while also providing the utmost in customer service. Our Values are public service, integrity, respect, responsiveness and sound judgment. We strive to not only provide affordable insurance products and services but also to provide sound financial responsibility to the citizens of Florida.
At Citizens, we are a team of dedicated, service-minded professionals committed to our policyholders. Come achieve and maximize your potential with us!

Under the direction of team leads and managers, this position is responsible for the design, implementation, management, and administration of enterprise database systems including the security, quality, recoverability, and integrity of data resources. This position may also have responsibility for functions such as user administration, database configuration, backup and restore, disaster recovery, deployment, and capacity management activities.

Models’ ethical behavior and executes job responsibilities in accordance with Citizen’s core values, ethics, and information protection policies

• Provide database administration for production and development environments including backup and recovery, performance tuning, physical sizing and monitoring activities, and support developers by influencing best practice, enforcing standards, and assisting with script execution.
• Understand, monitor, and administer database security and perform the role of gatekeeper in accordance with established security policies and audit guidelines.
• Contribute to the refinement of organizational standards and best practices, and champion quality service delivery by enforcing such standards.
• Install, configure, and evaluate multiple versions of RDBMS software including SQL Server and Oracle in both single-instance and high-availability methodologies.
• Support efforts to monitor and tune databases to improve performance throughout the system development lifecycle, including development and production environments as well as load tests simulating catastrophic event scenarios.
• Contribute to Total Cost of Ownership within the environments as it relates to licensing (Software, OS, tools), server costs, Cloud metering and Space/CPU utilization.

• High School Diploma | GED
• Associate/Technical Degree OR 2 years relevant experience, OR a combination of both college and experience equivalent to 2 years
• Bachelor’s degree in Computer Science/ Information Technology or related field OR 4 years of relevant experience OR a combination of college education and relevant work experience equivalent to 4 years
• 3 or more years of data system administration experience including running queries, generating statistics, analyzing data, and tuning and design, and 3 or more years of experience in standard database administration activities such as Backup and Recovery, Security and Authentication, Performance Tuning and Troubleshooting.

TECHNICAL SKILLS:

• MUST HAVE RECENT DBA experience with both Oracle and SQL DBs (required)
• SQL Server 2014 – 2016 DBA experience is required
• Solid knowledge of data manipulation and analysis tools such as Excel, Access, SQL, and SQL Stored Procedures (e.g., TSQL, PL/SQL, and similar languages) is required
• Solid knowledge of referential integrity and database normalization is required
• Solid knowledge of database normalization data modeling techniques and experience with database design is required
• Solid knowledge of Enterprise Systems Data Management and database best practices is required
• Experience in standard administration activities, such as Backup and Recovery, Security and Authentication, and Performance Tuning and Troubleshooting is required
• Experience with installation, configuration, and management of SQL Server
• Experience with after-hours support including troubleshooting jobs, disk space issues, etc.
• SQL Server or Oracle certifications would be a plus

Knowledge, Skills, Abilities:

• Experience with SQL Server and DB2
• Experience developing data models and data dictionaries with ERWin, PowerDesigner, Embarcadero, or similar tools.
• Strong performance monitoring and tuning experience.
• UNIX scripting and windows job automation skills.
• SQL Server, DB2 or Oracle certifications.

Other Skills and Abilities:
Ability to manage multiple tasks, work in a collaborative team environment; be responsive to project and customer needs, and work under tight deadlines
Ability to work under general supervision with few direct instructions
Ability to work well within a cross-functional development team building relationships with Developers, Testers, and Release Managers to collaborate and deliver database services.
Proven interpersonal, verbal, and written communication skills, including technical documentation skills
Service-oriented, self-motivated, with keen attention to detail
Knowledge or experience in Property & Casualty Insurance industry would be a plus

We offer unlimited career potential, excellent training and development opportunities, and a structured Career Development program to explore future roles of interest while growing and developing in your existing role.
Citizens offers a competitive compensation and benefits package that includes comprehensive medical/dental, Retirement Savings Plan, Vacation and Sick Time, EAP, Tuition Reimbursement, Community Service and much more!
Retirement savings plan with a generous company match
Medical, dental and vision coverage
Company Paid employee basic life insurance and short-term disability
Generous paid time off: vacation, sick and holiday leave
Employee Assistance and Wellness Programs
Tuition reimbursement
Professional and leadership development opportunities
Company Paid Parking
Employee recognition programs
Relocation assistance (where applicable)
Community and volunteering opportunities
Casual dress
Citizens is proud to be an Equal Opportunity Employer.
Visa sponsorship is not available for this position.
(for remote only)

Tags