Senior Database Administrator

Responsibilities & Qualifications

TekSynap seeks a highly experienced Senior Database Administrator to lead hands on design and implementation of software and databases in Microsoft SQL Server 2012 and/or newer. 

 

RESPONSIBILITIES 

• Use proven, efficient methodologies to support the Microsoft SQL Server and Structured Query Language (SQL) databases  

• Design and develop comprehensive database schemas, encompassing tables, views, indexes, triggers, stored procedures, functions, and other essential objects. 

• Craft efficient and optimized SQL queries, generate insightful reports, and seamlessly integrate data across various systems and applications. 

• Collaborate closely with end users and administrators to gain an understanding of their data needs, proactively optimize database performance, and uphold data quality standards. 

• Continuously monitor and optimize database performance through query tuning, index optimization, and resource management to ensure optimal efficiency and responsiveness. 

• Implement and enforce data security measures, including access controls, encryption, and authentication, to safeguard sensitive information and maintain compliance with relevant regulations 

• Create and maintain data models that accurately represent the organization's data structure and relationships, helping to guide database design decisions. 

• Document database architecture, configurations, and processes to ensure that knowledge is well-documented and can be easily transferred to other team members. 

• Develop and maintain Extract, Transform, Load (ETL) processes to move, transform, and load data from various sources into the database, ensuring data consistency and quality. 

• Perform capacity planning for future data growth and resource requirements, and plan for scaling the database infrastructure accordingly. 

• Plan and execute database migrations, ensuring minimal disruption to business operations. 

• Diagnose and resolve database-related issues, working closely with developers, system administrators, and other relevant teams to address technical challenges. 

• Formulates/defines system scope and objectives.  

• Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations.  

• Prepares detailed specifications from which programs will be written.  

• Designs, codes, tests, debugs, and documents those programs.  

REQUIRED QUALIFICATIONS 

• Five years of technical experience in applications software development, three of which are in systems analysis 

• 1 year of which is acting as technical lead. 

• Bachelor’s degree in Engineering/Computer Science or area related to the project’s functional requirement 

• Proficient with software languages, such as HyperText Markup Language (HTML), SQL, NoSQL, Python, or other languages as required. 

• Competent to work at a high level for all phases of system/database development/management 

• Must have the ability to pass a Background Investigation, ensuring compliance with security and regulatory requirements. 

 

DESIRED QUALIFICATIONS 

• Strong skills in SQL for querying and manipulating data in Microsoft databases. 

• Proficiency in PL/SQL for developing stored procedures, triggers and functions. 

• Proficiency in Microsoft Database management is essential.  This includes understanding database architecture, SQL, PL/SQL and database design principles. 

• Strong problem-solving skills to troubleshoot and resolve database-related issues. 

• Ability to design and implement database structures, including tables, indexes and constraints, to ensure data integrity and optimal performance. 

• Understanding performance tuning techniques and the ability to optimize database performance. 

 

COMPETENCIES   

• Oral Communication  

• Written Communication  

• Strategic Thinking 

• Technical Expertise 

• Initiative 

• Foster Innovation 

• Results Oriented 

• Teamwork  

Overview

We are seeking a Database Administrator to join our team supporting a government customer. TekSynap is a fast-growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment.