Envestnet is seeking a SQL Server Database Administrator to support, maintain, and optimize Microsoft SQL Server databases across on-premises and AWS cloud environments, ensuring the performance and availability of their financial technology platforms.
Requirements
- Proven experience with SQL Server 2017 or newer.
- Strong understanding of high-availability and high-transaction database environments.
- Working knowledge of cloud-hosted SQL Server deployments on AWS EC2 and AWS storage systems.
- Experience with virtualization technologies and distributed database concepts.
- Proficient in PowerShell scripting for automation and task management.
- Basic knowledge of Windows Server administration and IP networking.
- Experience working with other database platforms (e.g., PostgreSQL, MySQL, Snowflake).
Responsibilities
- Administer and maintain SQL Server databases hosted on both on-prem and AWS EC2 infrastructure.
- Configure and maintain SQL Server 2017 and newer instances in accordance with standardized configurations.
- Monitor performance and availability using tools such as SQL Sentry, RedGate, and New Relic.
- Troubleshoot and resolve performance issues and database errors in production and non-production environments.
- Develop and maintain PowerShell scripts to automate administrative tasks and support reporting needs.
- Participate in disaster recovery planning, backups, and database restore testing
- Apply industry best practices in database security, maintenance, and capacity planning.
Other
- This is a hybrid role, with in-office work required at our Berwyn, PA office location.
- Bachelor's degree in Computer Science, Information Technology, or equivalent work experience.
- 2–5 years of professional experience as a SQL Server DBA in a production environment.
- Relevant certifications in PostgreSQL, MS SQL, AWS, or database administration.
- Strong communication and collaboration skills.
