Job Description
Advanced Systems Design is seeking an Intermediate MS-SQL Data Base Administrator for our client located in Montgomery, AL .
This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.
Job Overview:
- SQL Server Database Administrator responsible for all aspects of database administration and data solutions.
- This role maintains standard and enterprise Microsoft SQL Server 2012 through 2019 data environments and detailed technical components on Hewlett-Packard (HP) physical and virtual servers running Microsoft Windows Server 2012 through 2019 operating systems.
- Managing data environments observed by competency in complex legacy SQL code modernization and concurrent new development.
- Ability to intelligently organize and document data processes is a must.
- Responsible for standards and design of physical data storage, maintenance, access and security administration.
- Performs backup and recovery on database management systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.
- This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
- Must also attend and participate in all assigned project onsite meetings.
- This position reports directly to the database manager and may at times report directly to the deputy director.
- This position’s onsite work schedule will be Monday through Friday 8:00 am-5:00 pm CST with a one (1) hour lunch period.
- The position will require after-business-hour availability for planned activities and for on-call support.
Required Qualifications:
- 5+ years of experience working with various database management systems in the areas of database design, testing, implementation, maintenance and administration in a multiple platform environment.
- 5+ years of experience in the role of a lead Microsoft SQL Server database administrator.
- Must have experience performing standalone installation, adding features to an existing installation, and upgrading of an existing instance of SQL Server to a different edition.
- Working knowledge of the SQL Server Installation Center for maintenance.
- Ability to comprehend and author complex and extensive SQL script is a must, with the expectations of maintaining and rewriting legacy processes to accommodate versioning and infrastructure changes.
- SQL programming skills should be denoted via efficient and effective syntax, acceptable peer code reviews, demonstrable product results, and documentation principles.
- Proficient with Data Manipulation Language (DML), Data Query Language (DQL), Data Definition Language (DDL), Data Control Language (DCL) and SQL Server Integration Services (SSIS) Packages as well as data management concepts such as normalization, aggregation, concurrency, and data modeling, to include data interchange formats such as JavaScript Object Notation (JSON).
- Security-driven concepts are top priority in all development and applied against standards set by the National Institute of Standards and Technology (NIST), Microsoft Trust Center (Azure Compliance), and any internal Departmental policies.
- Strong expertise in Data Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality, Functions, Views, and Triggers.
- Azure Cloud Services, BLOB Storage, SQL Data Tools, SQL Reporting Services and Amazon Web Services (AWS) are additional resources that the candidate should have work related experience with.
- Candidate must possess superior communication and documentation skills, strong decision-making and organizational attributes along with exceptional analytical and problem-solving skills.
- Candidate will work closely with Project Management, Application Designers, Peer Data Administrators, and Project Owners in workflow and business rule discovery, application design assistance, data modeling, and any applicable project-related implementation of process controls.
Preferred Qualifications:
- Redgate SQL Monitor for MS SQL Server and Oracle, Advanced Query Tool (AQT), and Quest Toad for DB2.
- Supporting and performing maintenance of DB2 11.5 LUW (Windows), DB2 12.0 z/OS, and/or ORACLE systems, therefore skills related to some, or all of the software and/or platforms.
Education Required:
- Bachelor’s Degree in: Computer Science, Information Systems, - OR - other related field with supporting work experience related to the Skills Required and Skills Preferred sections outlined in the Position Details.
Advanced Systems Design, Inc. is:
- A leading Information Technology provider for Federal, State & Local government agencies.
- A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.
- A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful innovative solutions for our government customers.
- A drug-free workplace in accordance with the Drug-Free Workplace Act of 1988.
- Applicants who have a signed offer of employment or contractor agreement are subject to:
- the pre-employment testing protocol:
- background investigation
- drug screening
Our Employees:
- Are actively working on next-generation technology projects with the U.S. Department of Veterans Affairs, CDC, and a wide array of Federal, State, and Local agencies throughout the United States
- Are eligible for wide-ranging benefits and perks, including but not limited to:
- Comprehensive Health Insurance with PPO and HDHP/HSA options
- Dental Insurance
- Vision Insurance
- Short/Long-Term Disability
- Group Life Insurance - Company Paid
- Voluntary Life Insurance
- 401(k) Plan with Employer Match
- Paid Time Off (Vacation/Sick)
- Holiday Pay - Company Paid Federal Holidays
- Tuition Assistance
- Professional Certification Incentive Plan
- Employee Referral Plan
- Technology Exposure
For additional information regarding Advanced Systems Design, please check out our WEBSITE or click HERE for all current job openings.
Advanced Systems Design is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Job Tags
Holiday work, Full time, Temporary work, For contractors, Work experience placement, Local area, Remote job, Work alone, Monday to Friday,