
Senior Database Administrator – Production Support
Posted 2 days ago

Posted 2 days ago
This is a fully remote position, open to applicants in Louisiana.
• Deliver production support for essential database environments, ensuring shift-based coverage and on-call assistance.
• Oversee database performance, handle incidents, troubleshoot production challenges, and coordinate service restoration efforts.
• Conduct root-cause analyses and contribute to initiatives aimed at enhancing long-term stability.
• Engage in Agile delivery processes, including daily scrums, biweekly sprint planning, and quarterly Program Increment planning.
• Establish operating standards and best practices focusing on performance, security, scalability, and maintainability.
• Define, manage, and coordinate data elements and standards.
• Facilitate effective data relationships, systems integration, and the development of physical data structures.
• Formulate and enforce database management policies and standards.
• Collaborate with Product Owners, users, agency leaders, stakeholders, consultants, and program personnel.
• Collect business requirements and translate them into technical specifications.
• Document intricate workflow designs for project teams and stakeholders.
• Analyze complex scenarios and data to bolster business strategies and methodologies.
• Gather, analyze, and interpret extensive datasets to inform business decisions.
• Employ statistical analysis, data mining, and predictive modeling techniques.
• Integrate data from diverse sources and create visualizations for KPIs and program metrics.
• Conduct peer reviews of developers’ code.
• Execute data validation to ensure accuracy and integrity.
• Design and develop stored procedures, jobs, views, tables, and other database objects using SQL Server Management Studio.
• Create scalable Databricks lakehouse data models utilizing bronze, silver, and gold layers, along with dimensional models, fact and dimension tables, and curated data products.
• Develop and deploy ETL packages leveraging CI/CD pipelines.
• Utilize configuration management systems for version control.
• Work with the Atlassian Suite.
• Index system and application logs in Splunk, and develop dashboards, alerts, and reports.
• Bachelor's degree in computer science, computer programming, computer engineering, or a related computer-based field, along with 5+ years of experience in server database maintenance and database analysis, or a similar role.
• Four or more years of additional experience may be accepted in place of a bachelor’s degree.
• Experience in supporting production database systems, including shift-based coverage and on-call responsibilities.
• Proficient experience with AWS database technologies such as Amazon Aurora PostgreSQL and other AWS-managed data services.
• Familiarity with Databricks and exposure to the AWS cloud platform.
• Experience in installing, configuring, and providing ongoing administrative support for database environments.
• Understanding of standard data warehouse concepts.
• Proficiency in data modeling, data mapping, data flow diagrams, and data marts.
• Experience in architecting and implementing cloud-based database solutions.
• Experience in migrating data from legacy on-premises databases to multi-cloud/hybrid cloud platforms.
• Ability to work autonomously, prioritize tasks, and complete assignments efficiently.
• Strong analytical, technical, and problem-solving abilities.
• Excellent organizational and time management skills.
• Effective communication skills with the ability to engage with individuals at all levels.
• Comfortable with drafting ideas, implementation plans, and status reports.
• Must be a US Person: Green Card Holder, US Permanent Resident Alien, Refugee, Asylee, or US Citizen.
• Must pass a background check to obtain Public Trust.
• Must provide onsite fingerprinting at a designated facility.
• Preferred certifications include: Databricks Certified Data Professional; AWS Certified Database – Specialty; AWS Certified Solutions Architect – Associate and/or Professional.
• AI-powered career tool identifying career steps and learning opportunities.
• Internal mobility team supporting career aspirations.
• Comprehensive benefits and wellness packages.
• 401(k) plan with company match.
• Competitive compensation.
• Paid time off.
• Medical plan options, including some with Health Savings Accounts.
• Dental plan options.
• Vision plan options.
• Flexible work weeks where feasible.
• Vacation, sick, personal, holiday, parental, military, bereavement, and jury duty leave.
• Typically, 15 days of paid leave per calendar year.
• 10 paid holidays annually.
• Up to 160 hours of paid family leave within a rolling 12-month period for eligible employees.
• Short- and long-term disability benefits.
• Life insurance coverage.
• Accidental death and dismemberment insurance.
• Personal accident insurance.
• Critical illness insurance.
• Business travel and accident insurance.
• Award-winning culture of innovation.
• Military-friendly workplace.
• Opportunities for career advancement.
• Identity verification process conducted through virtual interviews on camera.
TriSphere Apps
Alphabria
Jonas Software
Jonas Software
Get handpicked remote jobs straight to your inbox weekly.