Database Warehouse Analyst jobs in Bridgeport, CT

About Sacred Heart University:

As the second-largest independent Catholic university in New England, and one of the fastest-growing private doctoral institutions in the U.S., Sacred Heart University is a national leader in shaping higher education for the 21st century. SHU offers nearly 90 undergraduate, graduate, doctoral and certificate programs on its Fairfield, Conn., campus. Sacred Heart also has a campus in Dingle, Ireland, and offers online programs. More than 10,000 students attend the University's nine colleges and schools: Arts & Sciences; Communication, Media & the Arts; Social Work; Computer Science & Engineering; Health Professions; the Isabelle Farrington College of Education & Human Development; the Jack Welch College of Business & Technology; the Dr. Susan L. Davis, R.N., & Richard J. Henley College of Nursing; and St. Vincent's College. Sacred Heart stands out from other Catholic institutions as it was established and led by laity. The contemporary Catholic university is rooted in the rich Catholic intellectual tradition and the liberal arts, and at the same time cultivates students to be forward thinkers who enact change-in their own lives, professions and in their communities. The Princeton Review includes SHU in its Best 388 Colleges-2023 Edition, and Best Business Schools-2023 Edition. Sacred Heart is home to the award-winning, NPR-affiliated radio station, WSHU, a Division I athletics program and an impressive performing arts program that includes choir, band, dance and theatre. www.sacredheart.edu

View SHU's Faculty Experts Here

Job Description:

Responsible for the university's database management, ensuring availability, security and performance while also leveraging cloud technologies to scale and innovate.

PRINCIPAL DUTIES & RESPONSIBILITIES:

• Administer and maintain enterprise databases to ensure optimal performance, availability, and security.
• Perform routine database maintenance tasks, such as backups, updates, and patching.
• Troubleshoot and resolve database-related issues promptly.
• Maintain thorough and up-to-date documentation of database configurations, processes, and procedures to ensure knowledge retention and facilitate efficient troubleshooting and system management.
• Implement and manage cloud-based database solutions, utilizing platforms such as AWS, Azure, or Google Cloud.
• Migrate on-premises databases to the cloud, optimizing for scalability and cost-efficiency.
• Leverage cloud services for high availability, disaster recovery, and data analytics.
• Monitor database performance and proactively identify and resolve performance bottlenecks.
• Tune SQL queries and optimize database configurations for improved efficiency.
• Implement and enforce database security policies, ensuring data confidentiality and integrity.
• Stay updated on industry best practices and compliance requirements (e.g., GDPR, HIPAA) and ensure database compliance.
• Develop and maintain backup and recovery strategies to protect critical data.
• Perform data recovery in the event of system failures or data loss.
• Create and maintain automation scripts for routine tasks to improve operational efficiency.
• Implement infrastructure as code (IaC) principles to manage database resources.
• Collaborate with cross-functional teams, including developers, system administrators, and data analysts, to support application development and data-related projects.
• Other duties as assigned.

Requirements:

Working after hours and on weekends to complete assigned tasks is sometimes required.

KNOWLEDGE AND SKILLS NEEDED:

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent work experience).
• Proven experience as a Database Administrator with a focus on SQL Server.
• Strong proficiency in cloud computing platforms (e.g., AWS, Azure, Google Cloud).
• Knowledge of SQL Server high availability and disaster recovery solutions.
• Familiarity with database security best practices and compliance standards.
• Scripting skills (e.g., PowerShell, Python) for automation and task execution.
• Excellent problem-solving and communication skills.
• Ability to work independently and as part of a team in a fast-paced environment.

Preferred Qualifications:

• Experience working in a higher education setting.
• Certification in SQL Server or relevant cloud platform (e.g., Microsoft Certified: Azure Database Administrator, AWS Certified Database - Specialty).
• Experience with containerization and orchestration technologies (e.g., Docker, Kubernetes).
• Knowledge of big data and NoSQL databases (e.g., Hadoop, MongoDB).
• Familiarity with DevOps practices and CI/CD pipelines.

Additional Information:

Statement of Personal & Organizational Responsibility for Inclusive Excellence

Inclusive Excellence is the recognition that our institution's success is dependent on how well we value, engage, and include the rich diversity of students, staff, faculty, administrators, alums, and surrounding community. It is a mastery of inclusion that fosters a consistent sense of belonging. Inclusive Excellence is aspirational and is the pillar that guides the mission, vision, and function of this unit.

To achieve Inclusive Excellence, our personal and organizational responsibilities are to:

• Actively promote a collegial environment and consciously apply our mission and values to create a culture of inclusion and belonging; a safe space where all may thrive and succeed.
• Participate in educational and developmental activities to increase awareness and competencies of issues related to diversity, equity, inclusion, and belonging; apply that understanding to guide your approach to all aspects of your job and the community as a whole.
• Demonstrate that we are "Stronger Together" as described in the Office for Inclusive Excellence statements.

Application Instructions:

Please apply online, faxes and emails will not be accepted. A cover letter is appreciated.

Sacred Heart University is a space that respects and embraces differences, recognizes the unique contributions that individuals can make, and creates a community that maximizes the potential of all faculty and staff. As an equal opportunity employer, we encourage applications from qualified candidates who reflect the wider world in which we live.