Senior SQL Database Administrator
Nõutav:Security
This position is responsible for the planning, design and engineering of the Company's RDBMS environment (Microsoft SQL Server); acts as technical resource and as technical advisor to the development group; responsible for the tracking and resolution to SQL related problems and the communication of status to appropriate individuals; responsible for the stability of the Company's SQL replication model; manages the development of preventative maintenance procedures and methods; consults with development group on a variety of issues and provides support as required.
DUTIES & RESPONSIBILITIES
Database Architecture & Engineering:
- Design, plan, and engineer the Company's Microsoft SQL Server environment
- Implement and maintain SQL replication models for data accuracy
- Develop stored procedures, triggers, views, and other SQL objects
- Perform code reviews for all SQL changes
Performance & Optimization:
- Optimize database performance through indexing, query tuning, and configuration
- Design and test SQL Server business continuity plans
- Establish connectivity and access standards for SQL environments
Standards & Documentation:
- Create installation/software implementation standards for SQL systems
- Develop preventative maintenance procedures and methods
- Document database architectures and troubleshooting guides
Collaboration & Support:
- Act as technical advisor to development teams
- Resolve SQL-related problems and communicate status updates
- Consult on development projects requiring database expertise
REQUIREDQUALIFICATIONS:
Knowledge and Skills:
Technical Expertise
- Microsoft SQL Server (2012+ including Availability Groups)
- Transact-SQL programming (stored procedures, triggers, views)
- Replication, linked servers, and backup strategies
- ODBC/MDAC connectivity
- Windows Active Directory/SQL security integration
- DB2 SQL/400 (preferred)
Soft skills
- Excellent verbal/written communication
- Strong technical analysis and problem-solving
- Ability to work independently and collaboratively
Education and Experiences:
Required:
- Bachelor's degree
- 5+ years as Microsoft SQL Database Administrator
- Experience designing/implementing complex SQL projects