United States Job Openings
Advanced Systems Design
Database Analyst - 2235
Montgomery
FULL TIME
September 11, 2024
This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.
Job Overview:
- Senior Database Developer (Advanced) Senior level SQL Server and Azure Database Developer working both independently and within team environments that will operate in all aspects of RDBMS database design, security, and administration.
- Ability to comprehend and author complex and extensive SQL code 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, demonstratable product results, and documentation principles.
- Responsible for designing, modeling, developing and supporting Database Management Systems (DBMS).
- Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements.
- Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.
- Develops database and warehousing designs across multiple platforms and computing environments.
- Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.
- Typically has 6 to 10 years of IT work experience in DBA, DBMS design and support and relevant computing environments
- Ability to gather business requirements from process owners and translate that information into viable data models and elements supporting application development.
- 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), Penetration testing, and any internal departmental policies.
- Extended Experience utilizing the System Development Life Cycle (SDLC) process alongside the Agile development environment utilizing SRUM framework.
- Candidate will 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.
- Must also attend and participate in all assigned project meetings.
- Candidate should be extremely proficient with Data Manipulation Language (DML), Data Query Language, (DQL), and Data Control Language (DCL) as well as data management concepts such as normalization, aggregation, concurrency, and data modeling, to include data interchange formats such as Java Script Object Notation (JSON).
- Azure Cloud services, BLOB Storage, Dev Ops, SQL Data Tools, MS Power Apps, SQL Reporting Services, and MS Power BI are additional resources that the candidate should be highly provisioned for in the implementation of enterprise level services.
- Strong expertise in Data Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality, Functions, Views, and Triggers.
- This position reports directly to the section director and may require after business hour availability as related to stability of process controls.
- Must be able to pass ALEA background check.
- 5 years SQL Coding
- 5 years Azure SQL/DB
- 5 years Azure Cloud Services
- Master's Degree in Computer Science, Information Systems AND equivalent work experience. (6-10 years) Ability to gather business requirements from process owners and translate that information into viable data models and elements supporting application development.
- Bachelor’s Degree in Computer Science, Information Systems AND equivalent work experience. (6-10 years) Ability to gather business requirements from process owners and translate that information into viable data models and elements supporting application development.
- 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
-
the pre-employment testing protocol:
- 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
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.
foq Mdh1f Z9
New Job Alerts
Kampgrounds Of America
YEL - MAINTENANCE ENGINEER
West Yellowstone
November 19, 2024
View Job DescriptionAnytime Fitness - Milwaukee, WI
Anytime Fitness - Personal Training Manager
Milwaukee
November 19, 2024
View Job DescriptionValidaTek, Inc.
Senior Program Manager
Kearneysville
FULL TIME
November 19, 2024
View Job DescriptionState of Colorado Job Opportunities
Data and Technology Governance Manager
Denver
FULL TIME
November 19, 2024
View Job DescriptionPowerSchool Group LLC
Senior Account Manager, Strategic Sales TEXAS
FULL TIME
November 19, 2024
View Job DescriptionCadence Education
Preschool Lead Teacher
North Aurora
FULL TIME
November 19, 2024
View Job DescriptionUniversity of Missouri Health Care
NURSE TECH FULL-TIME NIGHTS - FLOAT POOL
Columbia
FULL TIME
November 19, 2024
View Job DescriptionAtlas Copco Compressors LLC
Industrial Equipment Sales Representative
Richmond
November 19, 2024
View Job DescriptionLooking for similar job?
United States Conference of Catholic Bishops
Software & Database Support Associate
Washington
FULL TIME
August 29, 2024
View Job DescriptionDecisionPoint | Cortek
Database Administrator
Boise
FULL TIME
September 6, 2024
View Job DescriptionLETTER CONCEPTS, INC.
Database Administrator
Berlin
FULL TIME
September 12, 2024
View Job DescriptionRaytheon
Senior Database Engineer (Onsite)
Richardson
FULL TIME
September 21, 2024
View Job DescriptionSee What’s New: Advanced Systems Design Job Opportunities
Advanced Systems Design
Manual Testing Technician - 2236
FULL TIME
September 12, 2024
View Job DescriptionNew Job Alerts
Kampgrounds Of America
YEL - MAINTENANCE ENGINEER
West Yellowstone
November 19, 2024
View Job DescriptionAnytime Fitness - Milwaukee, WI
Anytime Fitness - Personal Training Manager
Milwaukee
November 19, 2024
View Job DescriptionValidaTek, Inc.
Senior Program Manager
Kearneysville
FULL TIME
November 19, 2024
View Job DescriptionState of Colorado Job Opportunities
Data and Technology Governance Manager
Denver
FULL TIME
November 19, 2024
View Job DescriptionPowerSchool Group LLC
Senior Account Manager, Strategic Sales TEXAS
FULL TIME
November 19, 2024
View Job DescriptionCadence Education
Preschool Lead Teacher
North Aurora
FULL TIME
November 19, 2024
View Job DescriptionUniversity of Missouri Health Care
NURSE TECH FULL-TIME NIGHTS - FLOAT POOL
Columbia
FULL TIME
November 19, 2024
View Job DescriptionAtlas Copco Compressors LLC
Industrial Equipment Sales Representative
Richmond
November 19, 2024
View Job Description