Description
Job Summary: Administers, maintains, and implements policies and procedures for ensuring the security and integrity of the company’s databases. Resolves database performance issues, database capacity issues, synchronization, replication, and other distributed data issues. Assist with the development, review and testing of database objects and stored procedures using advanced programming techniques. Familiar with standard concepts, practices, and procedures within the labor market industry and security concepts. Works directly with clients and technical staff to support the company’s applications and operational data need. Consults with and advises users of the various organizational data sources and the tools available to access them. Works directly with developers and technical support personnel to anticipate and plan for productive data access, security and utilization. Relies on experience and judgment to plan and accomplish goals. Provides on call support for scheduled 24x7 time periods.
THIS IS A HYBRID POSITION. CANDIDATE MUST COME TO WORK AT CORPORATE OFFICE IN PALM HARBOR, FL. 3 DAYS A WEEK.
Duties and Responsibilities:
- Demonstrate effective communication and interpersonal skills
- Deliver expertise in MS SQL database technology
- Perform daily health checks and ensure recovery strategies are functioning
- Troubleshoot, identify and resolve database issues in a timely manner
- Provide off-hours on-call support and work in unison with system engineers
- Take responsibility for performance and health of all company databases
- Support all software development life-cycle database environments
- Collaborate with solution architects to devise enterprise level data strategies
- Mentor development teams and assist with new and existing data interfaces
- Enforce naming, coding, design, deployment and security standards
- Enhance current methods, policies, procedures and processes
- Produce high quality documentation
Requirements
Work Experience / Knowledge:
- Experience as a SQL DBA in a SQL Server 2012 or higher environment
- Ability and willingness to provide off-hours on-call support
- Strong analysis, decision-making, and communication skills
- Good command of T-SQL programming
- Experience in a high transaction volume, 24x7, VLDB, enterprise database environment
- Understanding of SQL clustering
- Familiarity with log shipping, database snapshots and mirroring
- Can support data synchronization across multiple environments
- Understanding of database security and access
- Knowledge of data modeling techniques and tools
- Ability to excel in a large, fast-paced database environment
- Fortitude to enforce, practice and improve database standards and deployment processes
- Performance tuning and indexing expertise including execution plan analysis
- Experience administering transactional replication a plus
- Working experience with Reporting Services a plus
Qualifications / Certifications:
- Bachelor's degree in Computer Science, Information Systems or related field
- Minimum 4 years database administration experience in appropriate technical environment. Experience in the labor market or regulatory occupation industries preferred
Special Requirements:
- May also be assigned various projects and tasks as needed
Skills Required
- Experience as a SQL DBA in a SQL Server 2012 or higher environment
- Ability and willingness to provide off-hours on-call support
- Strong analysis, decision-making, and communication skills
- Good command of T-SQL programming and stored procedures
- Experience in a high transaction volume, 24x7, VLDB, enterprise database environment
- Understanding of SQL clustering
- Familiarity with log shipping, database snapshots and mirroring
- Ability to support data synchronization across multiple environments
- Understanding of database security and access controls
- Knowledge of data modeling techniques and tools
- Performance tuning and indexing expertise including execution plan analysis
- Experience administering transactional replication
- Working experience with Reporting Services (SSRS)
- Bachelor's degree in Computer Science, Information Systems or related field
- Minimum 4 years database administration experience
- Hybrid: must work onsite at corporate office in Palm Harbor, FL three days per week
What We Do
Established in 1992, Geographic Solutions, Inc. is the nation's leading provider of software solutions for the workforce development, labor market information, and unemployment insurance industries. We have developed advanced online solutions for state and local government agencies in more than 35 states. We are a privately-owned company headquartered in Palm Harbor, FL with a satellite office in Salinas, CA. We currently employ over 350 full-time employees, who are all located in the United States and have decades of combined experience in developing online solutions designed for employment agencies, educational institutions, economic development departments, and correction facilities. Our in-house staff includes .NET developers, business analysts, project managers, technical writers, quality assurance analysts, training specialists, network administrators, database architects, and more. Examples of websites we have implemented and currently manage include: Employ Florida (www.employflorida.com) CalJOBS (www.caljobs.ca.gov) NCWorks (www.ncworks.gov) Indiana Career Connect (www.indianacareerconnect.com) .... and many others! Our recent company awards include: Tampa Bay Tech Technology Project of the Year Winner (2018 & 2020) Tampa Bay Business Journal: The List - Largest Software Developers in Tampa Bay (2013 & 2020) Bright House Networks Regional Business Awards First Place - Large Business (2016) Bright House Networks Regional Business Awards 2nd Place in Large Business Category (2015) Greater Palm Harbor Chamber of Commerce Large Business of the Year (2015, 2016, 2017, and 2018) U.S. Department of Labor’s ‘Tools for Job Seekers’ Challenge – Employ Florida Marketplace (First Place Ranking), America’s Virtual OneStop (Third Place Ranking) American Heart Association Fit-Friendly Worksite Gold Achievement (2015 & 2016)









