Company Intro:
EdgeCo Holdings is comprised of several affiliated companies focused on providing a broad array of sophisticated financial products, technology, and support services in the areas of full-service retirement plan administration, brokerage services, and trust & custody solutions. EdgeCo provides these services through numerous subsidiary entities including American Trust, Mid Atlantic Trust Company, NewEdge Capital Group and PensionPro Software.
Job Summary:
The Senior Database Administrator (Sr. DBA) with EdgeCo Holdings, is part of the Network Engineering department, and plays a leading role in defining, developing and documenting the structure and security of production services and databases for our organization. As a Sr. DBA, you will be responsible for monitoring and alerting for performance and errors and proactively planning and managing all aspects of database administration. You will have the opportunity to work closely with all functional verticals within EdgeCo to ensure smooth customer implementations and compliance with all system standards and directions.
Ideal candidates for the Sr. DBA position will be located in the Greater Denver, CO area. While this position will work in a remote capacity the majority of the time, there will be occasional on-site needs at our data center in Denver, CO.
Duties/Responsibilities:
Deploy, configure, and manage large-scale MS SQL, Oracle Standard and Oracle Enterprise, relational databases.
Monitor and optimize these instances to ensure database performance and manage database capacity planning.
Develop and support database replication across multiple data centers including the DR site.
Manage the backup and recovery procedures for all databases within the production, testing, and development environments.
Work with the Infrastructure team to monitor and update disaster recovery plans where required.
Build database schema, tables, procedure, and permissions.
Install and test upgrades and patches.
Troubleshoot database issues; maintain database systems availability and scalability.
Develop and optimize database design for new and existing applications.
Provide technical expertise to ensure the successful operation of the hosted environment.
Perform software installations, upgrades, and migrations as required.
Play a core role in ensuring code updates are planned and implemented smoothly following all operational procedures.
Ensure that all tickets are properly documented, prioritized, and completed according to our SLAs with our customers.
Acquire and maintain knowledge of internal information systems; help evolve system features, functionality, and usability to support company requirements.
Microsoft Power BI Services and Tool Integration, Deployment and Support (or comparable Business Intelligence toolset).
Maintain MS SQL availability groups.
Maintain Oracle database replication.
Maintain a high level of confidentiality at all times.
Skills/Abilities:
Intimate knowledge of Windows Server OS and extensive experience in database administration of relational databases, specifically MS SQL Server, Microsoft Azure SQL Database, and Oracle.
A solid understanding of networking/distributed computing environment concepts; understands principles of routing, client/server programming, the design of consistent network-wide file system layouts, high traffic/high availability networking concepts like load balancing, clustering.
Experience working with load balancing technologies and large-scale web server farms. Thorough grasp of web application architecture, including TCP/IP, HTTP, load balancing, caching strategies and other common components.
Solid working experience with Microsoft IIS, scripting (PowerShell, etc.), SSIS, SSRS, SSMS, and SQL Server transactional replication.
Experience with MS SQL Server replication/clustering and partitioning/sharding a must.
Experience writing and executing stress tests on databases and services.
Experience with cloud services Azure VM and PaaS and hosting relational databases on cloud services.
A solid understanding of operational security concepts and strategies and how they relate to Web applications.
Strong OS and application scripting skills.
Experience monitoring web server performance.
Excellent understanding of database support, operation, and SQL administration.
Must possess excellent written (email) and verbal communication and be able to interact effectively and professionally with other teams and Engineers.
Ability to rapidly assess, analyze and resolve complicated issues with little initial information or direction and with varying degrees of ambiguity.
Able to organize and prioritize work in a super-fast-paced environment with the ability to resolve multiple interrupt-driven priorities simultaneously is a must.
Education and Experience:
Bachelors degree in Computer Science, Computer Information Systems, or related field
5-10 years experience in database design, implementation, and administration of large, complex, and mission critical relational databases
Salary: $120,000 – $130,000
Benefits:
Employees are eligible to participate in company benefits including health, dental, and vision insuranceon the first of the month after their hire date. The company also provides a 401(k) plan with company match, group life insurance, short- and long-term disability, as well as additional voluntary benefits for employees to elect participation in.