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.
Location: Pittsburgh, PA working in a hybrid capacity
Duties/Responsibilities:
- Deploy, configure, and manage large-scale MS SQL relational databases utilizing Availability Groups
- Monitor and optimize these instances to ensure database performance and manage database capacity planning.
- Develop and support database Availability group 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 SDLC 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.
- Maintain Microsoft SQL (2017-2022) availability groups.
- Maintain a high level of confidentiality at all times.
Experience & Education:
- Bachelor’s 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
- Intimate knowledge of Windows Server OS and extensive experience in database administration of relational databases, specifically MS SQL Server, Microsoft Azure SQL Database.
- Experience with vmWare for SQL VM server management.
- A solid understanding of networking/distributed computing environment concepts; understand principles of routing, client/server programming, the design of consistent network-wide file system layouts, high traffic/high availability networking concepts like load balancing, and 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 in writing SQL stored procedures.
- Experience writing and executing stress tests on databases and services.
- Experience with Azure SQL 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.