Senior Database Administrator

Responsibilities & Qualifications

Tek Synap 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.

• 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
• Formulate and define 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, writes, tests, debugs, and documents those programs

• Five years of technical experience in applications software development, three of which are in systems analysis
• One year of which is acting as technical lead
• Bachelor’s degree in Engineering/Computer Science or a field related to the project’s functional requirement
• Proficient with software languages, such as Hyper Text Markup Language (HTML), SQL, No
  
  SQL, Python, or other languages as required
• Competent to work at a high level for all phases of system/database development and management
• Must have the ability to pass a Background Investigation, ensuring compliance with security and regulatory requirements

• 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

• Oral Communication
• Written Communication
• Strategic Thinking
• Technical Expertise
• Initiative
• Foster Innovation
• Results Oriented
• Teamwork

We are seeking a Database Administrator to join our team supporting a government customer. Tek Synap 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. “Technology moving at the speed of thought” embodies these principles – the need to nimbly utilize the best that information technology offers…