Advanced Systems Design is seeking a Data Base Administrator, Intermediate for our client located in Montgomery, AL.
This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.
Job Overview:
The resource in this position will handle database administration for mission-critical transactional and Datawarehouse SQL servers, with a significant focus on continuous improvement and technology strategy.
The resource manages and maintains all production and non-production databases; is 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, performance, and cost.
Additionally, this position will handle web administration for mission-critical web servers, significantly focusing on web applications' deployment, connectivity, and maintenance.
This will include expert escalation for troubleshooting production issues, assisting in the development lifecycle, capacity management, and strategy, operational standards and procedures, stabilization and optimization, performance tuning and monitoring, standards identification and compliance, continuous improvement, and security enhancement.
The Database Administrator (DBA) in this position must have a passion for data, databases, and web applications, and bring expertise to help us deliver best-in-class data delivery solutions.
Required Qualifications:
8+ years of experience working as MS SQL Server database administrator and database internals, with a strong focus on SQL Server 2016, 2019, and 2022;
8+ years in SQL Server database performance tuning along with a good understanding of indexing, execution plans, DMV, database storage, database problem identification, problem diagnosis, and resolution;
8+ years writing scripts or using leading tools to monitor, perform backup & recovery, and maintenance automation; hands-on experience in on-prem to cloud migration; hands-on experience in creating and troubleshooting SSIS packages;
5+ years of experience in performing code;
5+ years of experience with MS Internet Information Services (IIS) with a strong focus on server administration and web applications deployment.
Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, systems feeds, and interfaces) with multiple concurrent users, ensuring control, integrity, and accessibility of data.
Works on multiple projects as a project leader or sometimes as a project advisor.
May coach more junior technical staff.
Advanced knowledge in MS SQL Server and Datawarehouse, MS Internet Information Services (IIS), PowerBI, and SSAS;
Advanced knowledge in creating, deploying, and monitoring SSIS packages;
Good knowledge of maintaining SQL report servers (SSRS);
Good knowledge of SQL server encryption;
Familiar with industry-level best practices for Microsoft SQL Server security standards;
Expert knowledge of backup & recovery;
Expert knowledge of on-prem to cloud migration;
Good knowledge of Azure, industry-standard server hardware, operating systems, storage, virtualization, and networking technologies;
Familiar with PowerShell, database source control, and continuous integration tools;
Familiar with RedGate, Tableau, and Idera Data Architect tools;
Strong problem-solving skills and a commitment to getting things done right; eagerness to learn and help others; good written and verbal communication skills and professionalism.
Preferred Qualifications:
5+ years of experience with creating SSIS packages.
Power BI capacity Admin, connecting gateways to data sources, granting access permissions, creating workspaces, publishing Power BI reports and dashboards.
Familiar with Snowflake; strong teamwork and interpersonal skills with the ability to communicate and persuade all levels of management.
Education Required:
Bachelor's Degree in Computer Science, Information Systems, or other related field.
Education Preferred
Microsoft Certification in SQL Server Database Administration.
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 (http://www.asd-web.com) or click HERE (http://www.asd-web.com/careers) 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.
Powered by JazzHR
