Senior Database Architect
About The Position
Designs, implements, and maintains the full lifecycle of complex databases including Tables, Views, Stored procedures, indexes, functions, jobs, rules and roles, replications, and other database objects. Understands and maintains database interaction with other mission-critical systems. Manages or develops databases with respect to the operating system, access methods, and access time. Creates or maintains database clustering. Creates, monitors, and troubleshoots database replications. Provides highly technical expertise in the use of database management systems. Defines file organization, indexing methods, and security procedures for specific user applications. Conducts device allocation, validation checks, organization, and statistical methods. Maintains database dictionaries. Integrates systems through database design. Works in collaboration with Development and Engineering teams. Evaluates and recommends available database management products and services. Follows database standards and plays a quality assurance role.
Requirements
- Ten (10) years of technical experience, of which includes at least five years of specialized experience.
- Significant prior experience in supporting MS SQL server 2016, 2019 or later versions
- BA/BS in Technical, Engineering or Management field.
- Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse.
- Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred.
Nice To Haves
- Experience supporting federal project.
- Master's Degree can be substituted with Four( 4) additional years of experience.
Responsibilities
- Designs, implements, and maintains full life cycle of complex databases including Tables, Views, Stored procedures, indexes, functions, jobs, rules and roles, replications, and other database objects.
- Understands and maintains database interaction with other mission critical systems.
- Manages or develops databases with respect to the operating system, access methods, and access time.
- Creates or maintains database clustering.
- Creates, monitors and trouble shoots database replications.
- Provides highly technical expertise in the use of database management systems.
- Defines file organization, indexing methods, and security procedures for specific user applications.
- Conducts device allocation, validation checks, organization, and statistical methods.
- Maintains database dictionaries.
- Integrates systems through database design.
- Works in collaboration with Development and Engineering teams.
- Evaluates and recommends available database management products and services.
- Follows database standards and plays quality assurance role.
Benefits
- Medical, Rx, Dental & Vision Insurance
- Personal and Family Sick Time & Company Paid Holidays
- Parental Leave
- 401(k) Retirement Plan
- Group Term Life and Travel Assistance
- Voluntary Life and AD&D Insurance
- Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
- Transit and Parking Commuter Benefits
- Short-Term & Long-Term Disability
- Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
- Employee Referral Program
- Corporate Sponsored Events & Community Outreach
- Care.com annual membership
- Employee Assistance Program
- Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
- Position may be eligible for a discretionary variable incentive bonus
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
