TekSynap is currently seeking a skilled SQL Database Administrator to join their team. The chosen candidate will be responsible for various activities related to the administration of computerized databases, including designing and maintaining databases, conducting quality control and auditing, and providing advice to users on database access. They must have at least five years of progressive experience in database query languages and hands-on experience with Relational Database Management Systems. Additionally, expertise in enterprise Microsoft SQL Server and IBM DB2 is required, along with an active Secret clearance and relevant IT certifications. This position offers a competitive benefits package and the opportunity to work with a fast-growing, high-tech company that values information management.
Find out the Best Money Saving Products
Responsibilities
Administration of computerized databases
The SQL Database Administrator is responsible for the administration of computerized databases. This includes tasks such as creating, maintaining, and optimizing databases, ensuring data integrity, and managing users and access levels. The administrator is also responsible for troubleshooting any issues with the databases and resolving them in a timely manner.
Long-range requirements for database administration
The SQL Database Administrator works with other managers in the information systems function to project long-range requirements for database administration and design. This involves analyzing the current database infrastructure and identifying any necessary changes or improvements that need to be made in order to meet future needs. The administrator must stay up to date with the latest trends and advancements in database administration to ensure the long-term success of the organization’s database systems.
Design and maintenance of client/server databases
The SQL Database Administrator is responsible for designing and maintaining client/server databases. This includes creating the database schema, implementing security measures, and optimizing database performance. The administrator must also ensure that all client/server databases are compatible with the organization’s existing infrastructure and systems.
Quality control and auditing of databases
The SQL Database Administrator is responsible for conducting quality control and auditing of databases to ensure accurate and appropriate use of data. This includes verifying the accuracy of data, identifying any anomalies or errors, and implementing measures to prevent data corruption or loss. The administrator must ensure that all databases meet industry standards and comply with relevant regulations and policies.
User advisory on database access
The SQL Database Administrator advises users on access to various client/server databases. This includes providing guidance on how to use the databases effectively and securely, as well as assisting users with any issues or questions they may have. The administrator must have strong communication skills and the ability to explain complex technical concepts in a clear and concise manner.
Design and maintenance of complex databases
The SQL Database Administrator is responsible for designing and maintaining complex databases. This includes working with stakeholders to understand their requirements and translating them into database structures. The administrator must also ensure that complex databases are optimized for performance and scalability, and that they can handle large amounts of data and high user loads.
Database programming and systems design
The SQL Database Administrator is responsible for database programming and systems design. This includes writing and optimizing database queries, creating stored procedures and triggers, and designing database schemas. The administrator must have strong programming skills and be proficient in SQL and other relevant languages and technologies.
Maintenance of database dictionaries and standards
The SQL Database Administrator is responsible for maintaining database dictionaries and standards. This includes documenting the structure and relationships of database objects, as well as defining naming conventions and data standards. The administrator must ensure that all databases adhere to these standards and that any changes or updates are properly documented.
Integration of systems through database design
The SQL Database Administrator is responsible for integrating systems through database design. This includes designing and implementing data integration processes, creating data interfaces, and ensuring that data flows smoothly between different systems. The administrator must have a deep understanding of the organization’s systems and processes in order to design effective database integrations.
Required Qualifications
Five (5) years progressive experience with database query languages
The SQL Database Administrator must have at least five years of progressive experience with database query languages. This includes proficiency in SQL and other relevant query languages, as well as a deep understanding of database query optimization techniques.
Expertise in Relational Database Management Systems
The SQL Database Administrator must have expertise in Relational Database Management Systems (RDBMS). This includes a thorough understanding of RDBMS concepts and principles, as well as experience in working with popular RDMBS platforms such as Microsoft SQL Server and IBM DB2.
Experience in large-scale computer database administration
The SQL Database Administrator must have experience in large-scale computer database administration. This includes a proven track record of successfully managing and maintaining large databases, as well as a deep understanding of the challenges and best practices associated with administering databases at scale.
Expert with enterprise Microsoft SQL Server and IBM DB2
The SQL Database Administrator must be an expert with enterprise Microsoft SQL Server and IBM DB2. This includes a thorough understanding of these platforms’ features and capabilities, as well as experience in optimizing database performance and ensuring data security on these platforms.
Active Secret clearance with IT-I sensitivity
The SQL Database Administrator must have an active Secret clearance with IT-I sensitivity. This is necessary to access classified information and ensure the security and integrity of the organization’s databases.
IAT II or III certifications in Security+
The SQL Database Administrator must have IAT II or III certifications in Security+. This includes a comprehensive understanding of information security principles and best practices, as well as experience in implementing and maintaining security measures in a database environment.
Specific certifications related to computing environment and database administration
The SQL Database Administrator must have specific certifications related to the computing environment and database administration. This includes certifications in relevant technologies and platforms, as well as certifications that demonstrate expertise in database administration principles and practices.
Find out the Best Money Saving Products
TekSynap SQL Database Administrator
Joining the team supporting DLA Enterprise Database Infrastructure Services
The SQL Database Administrator will be joining the TekSynap team that supports the DLA Enterprise Database Infrastructure Services. This is an exciting opportunity to work with a team of experienced professionals and contribute to the success of a large-scale database infrastructure.
Location options: Battle Creek, MI; Columbus, OH; Dayton, OH; Fort Belvoir, VA; New Cumberland, PA; Ogden, UT; Philadelphia, PA; Richmond, VA
The SQL Database Administrator will have the option to work in various locations, including Battle Creek, MI; Columbus, OH; Dayton, OH; Fort Belvoir, VA; New Cumberland, PA; Ogden, UT; Philadelphia, PA; and Richmond, VA. This provides flexibility and the opportunity to work in a location that is convenient and suitable for the individual.
About TekSynap and its focus on information management environment
TekSynap is a fast-growing high-tech company with a focus on creating comprehensive, well-planned information management environments. The company emphasizes the importance of utilizing the best technology to meet the business needs of its federal government customers. The SQL Database Administrator will have the opportunity to work in a dynamic and innovative organization that values technology and information management.
Benefits package for full-time employees
TekSynap offers a competitive benefits package for full-time employees. This includes health, dental, and vision insurance, a 401K retirement plan, life insurance, short-term and long-term disability plans, vacation time, and holidays. The company values the well-being and satisfaction of its employees and strives to provide a comprehensive benefits package.
Work Environment and Physical Demands
Office environment with medium noise level
The SQL Database Administrator will work in an office environment with a medium noise level. This requires the ability to concentrate and focus on the tasks at hand, despite potential distractions.
Day shift schedule with possible evenings and weekends
The SQL Database Administrator will work on a day shift schedule, typically from Monday to Friday. However, there may be occasions where work outside of normal business hours, such as evenings and weekends, is necessary to meet program and contract needs.
At least 10% travel required
The SQL Database Administrator will be required to travel at least 10% of the time. This may involve visiting different locations where databases are deployed, attending conferences or training sessions, or collaborating with other teams or clients.
Physical demands including handling, reaching, talking, and lifting
The SQL Database Administrator may be required to perform physical tasks as part of their duties. This may include handling equipment, reaching for items, engaging in verbal communication with colleagues or clients, and lifting objects weighing up to a certain amount.
Vision requirements and ability to adjust focus
The SQL Database Administrator must meet the vision requirements necessary to perform their job duties. This includes having clear vision, depth perception, and the ability to adjust focus as needed.
Work Authorization/Security Clearance
US Citizen with Secret Clearance
The SQL Database Administrator must be a US Citizen and hold an active Secret Clearance. This is necessary to meet the security requirements of the organization and access classified information.
Other Duties
Not a comprehensive listing of activities, duties, or responsibilities
The information provided in this article is not intended to be a comprehensive listing of all activities, duties, or responsibilities associated with the role of a SQL Database Administrator. The specific tasks and responsibilities may vary depending on the organization and its unique requirements.
Changes may occur with or without notice
It is important to note that changes may occur in the responsibilities, qualifications, and work environment of a SQL Database Administrator with or without notice. These changes may be driven by factors such as advancements in technology, shifts in organizational priorities, or changes in industry regulations.
Equal Employment Opportunity
Merit-based employment decisions
TekSynap is committed to making merit-based employment decisions. This means that all employment decisions, including hiring, promotion, and compensation, will be based on the individual’s merit, qualifications, and abilities.
Non-discrimination policy based on protected status
TekSynap has a non-discrimination policy that prohibits discrimination based on protected status. This includes factors such as race, color, creed, religion, sex, sexual orientation, gender identity, protected veteran status, national origin, disability, age, genetic information, or any other characteristic protected by law. The company is committed to providing a fair and inclusive work environment for all employees.
Reasonable accommodations for individuals with disabilities
TekSynap provides reasonable accommodations for individuals with disabilities to ensure equal employment opportunities. If an individual requires a reasonable accommodation to perform their job duties or participate in the hiring process, they can contact hr@teksynap.com for assistance.
Similar Jobs at TekSynap
Senior Systems Administrator
In addition to the SQL Database Administrator role, TekSynap offers similar jobs such as Senior Systems Administrator. This is another opportunity to work with the organization’s information management environment and contribute to the success of its clients.
Unix Administrator
TekSynap also offers the position of Unix Administrator. This role involves managing and maintaining Unix-based systems and ensuring their optimal performance and security.
Navigation
About Us
The “About Us” section provides information about TekSynap, including its mission, vision, and values. It may also include information about the company’s history, leadership team, and key achievements.
Contact Us
The “Contact Us” section provides contact information for individuals who wish to reach out to TekSynap for inquiries, collaboration opportunities, or any other purpose. This typically includes phone numbers, email addresses, and possibly a contact form.
Terms & Conditions
The “Terms & Conditions” section outlines the terms and conditions that govern the use of TekSynap’s services or website. This may include information on liability, intellectual property, privacy, and other legal aspects.
Privacy Policy
The “Privacy Policy” section describes how TekSynap collects, uses, and protects personal information. It typically includes information on data collection methods, data retention, and individuals’ rights regarding their personal information.
Do Not Sell My Info
The “Do Not Sell My Info” section provides individuals with the option to opt out of the sale of their personal information. This is in compliance with applicable privacy laws, such as the California Consumer Privacy Act (CCPA).
Help
The “Help” section provides individuals with resources and information to help them navigate TekSynap’s services or website. This may include FAQs, user guides, tutorials, or customer support contact information.
Fraud
The “Fraud” section provides information on how to identify and report fraudulent activities related to TekSynap’s services or website. This may include guidance on identifying phishing emails, reporting suspicious activities, or seeking assistance in case of fraud.
Terms of Sale
The “Terms of Sale” section provides the terms and conditions that apply to the sale of products or services by TekSynap. This typically includes information on payment methods, delivery or shipping policies, warranties or guarantees, and returns or refunds.
Top Workplaces
2021 Star Nurses Finalists
TekSynap was recognized as a 2021 Star Nurses Finalist. This recognition highlights the organization’s commitment to providing a positive and supportive work environment for nurses.
Twitter Feeds
TekSynap’s Twitter feeds provide real-time updates and information about the organization, its services, industry trends, and relevant news. Followers can stay up to date with the latest developments and connect with TekSynap through this social media platform.
