Geographic Solutions
Senior Database Administrator
Geographic Solutions, Palm Harbor, Florida, United States, 34683
Job Summary:
The Senior SQL Database Administrator designs, models, configures, tests and installs databases independently. The Sr. SQL Database Administrator provides support services for database creation, performance, monitoring, tuning and capacity planning. Designs and builds physical data structures. Recommends, develops and enforces policies and procedures for maintaining the security and integrity of the database and ensures the database meets availability and disaster recover requirements. 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. Functions as lead on projects and may lead teams. Coaches the development of other SQL DBAs. Implements complex large/multiple development projects. SQL Database administrator is responsible for understanding concepts and implementation of Windows Server clusters, SQL Server clusters, availability groups, and disaster recovery. 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.
Viable candidates must be willing to work onsite at GSI's headquarters in Palm Harbor, Florida three (3) days per week
Key Responsibilities:Develops and implements complex and large databases supporting enterprise systems.Performs all aspects of database management including installation, patching, backup and recovery, performance and tuning, security administration and space management.Demonstrate effective communication and interpersonal skillsDeliver expertise in MS SQL database technologyPerform daily health checks and ensure recovery strategies are functioningTroubleshoot, identify and resolve database issues in a timely mannerProvide off-hours on-call support and work in unison with system engineersTake responsibility for performance and health of all company databasesSupport all software development life-cycle database environmentsCollaborate with solution architects to devise enterprise level data strategiesMentor development teams and assist with new and existing data interfacesEnforce naming, coding, design, deployment and security standardsEnhance current methods, policies, procedures and processesProduce high quality documentationRequirements
Work Experience / Knowledge:
Expert as a SQL DBA in a SQL Server 2012 or higher environmentAbility and willingness to provide off-hours on-call supportStrong analysis, decision-making, and communication skillsExcellent command of T-SQL programmingExperience in a high transaction volume, 24x7, VLDB, enterprise database environmentExcellent understanding of SQL clusteringExpert with log shipping, database snapshots and mirroringCan support data synchronization across multiple environmentsUnderstanding of database security and accessKnowledge of data modeling techniques and toolsAbility to excel in a large, fast-paced database environmentFortitude to enforce, practice and improve database standards and deployment processesPerformance tuning and indexing expertise including execution plan analysisExperience administering transactional replication a plusWorking experience with Reporting Services a plusQualifications / Certifications:
Bachelor's degree in Computer Science, Information Systems or related fieldMinimum 4 years database administration experience in appropriate technical environment. Experience in the labor market or regulatory occupation industries preferredSpecial Requirements:
May also be assigned various projects and tasks as needed
Equal Opportunity Employer. M/F/D/V
The Senior SQL Database Administrator designs, models, configures, tests and installs databases independently. The Sr. SQL Database Administrator provides support services for database creation, performance, monitoring, tuning and capacity planning. Designs and builds physical data structures. Recommends, develops and enforces policies and procedures for maintaining the security and integrity of the database and ensures the database meets availability and disaster recover requirements. 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. Functions as lead on projects and may lead teams. Coaches the development of other SQL DBAs. Implements complex large/multiple development projects. SQL Database administrator is responsible for understanding concepts and implementation of Windows Server clusters, SQL Server clusters, availability groups, and disaster recovery. 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.
Viable candidates must be willing to work onsite at GSI's headquarters in Palm Harbor, Florida three (3) days per week
Key Responsibilities:Develops and implements complex and large databases supporting enterprise systems.Performs all aspects of database management including installation, patching, backup and recovery, performance and tuning, security administration and space management.Demonstrate effective communication and interpersonal skillsDeliver expertise in MS SQL database technologyPerform daily health checks and ensure recovery strategies are functioningTroubleshoot, identify and resolve database issues in a timely mannerProvide off-hours on-call support and work in unison with system engineersTake responsibility for performance and health of all company databasesSupport all software development life-cycle database environmentsCollaborate with solution architects to devise enterprise level data strategiesMentor development teams and assist with new and existing data interfacesEnforce naming, coding, design, deployment and security standardsEnhance current methods, policies, procedures and processesProduce high quality documentationRequirements
Work Experience / Knowledge:
Expert as a SQL DBA in a SQL Server 2012 or higher environmentAbility and willingness to provide off-hours on-call supportStrong analysis, decision-making, and communication skillsExcellent command of T-SQL programmingExperience in a high transaction volume, 24x7, VLDB, enterprise database environmentExcellent understanding of SQL clusteringExpert with log shipping, database snapshots and mirroringCan support data synchronization across multiple environmentsUnderstanding of database security and accessKnowledge of data modeling techniques and toolsAbility to excel in a large, fast-paced database environmentFortitude to enforce, practice and improve database standards and deployment processesPerformance tuning and indexing expertise including execution plan analysisExperience administering transactional replication a plusWorking experience with Reporting Services a plusQualifications / Certifications:
Bachelor's degree in Computer Science, Information Systems or related fieldMinimum 4 years database administration experience in appropriate technical environment. Experience in the labor market or regulatory occupation industries preferredSpecial Requirements:
May also be assigned various projects and tasks as needed
Equal Opportunity Employer. M/F/D/V