About This Role
Designing and architecting database solutions is the core of this role, which also involves triaging complex issues at level 3 and acting as a subject matter expert for application support. The administrator will provide in-depth database expertise from design to performance and deployment, automate mundane tasks, and bring new skills and technology to support applications with the latest designs and features. Exposure to cloud database technologies and free RDBMS/No-SQL experience is an added advantage. This position is responsible for the standards and design of physical data storage, maintenance, access, and security administration.
Responsibilities
- Design and architect database solutions
- Optimize database access and allocate/re-allocate database resources for optimum configuration, database performance, and cost
- Perform data analysis to provide management with timely and accurate information and predict future requirements
- Ensure service level agreements are met for internal and external clients
- Provide strategic engineering solutions to drive technological improvements
- Take ownership of projects to ensure successful implementation, including tech-stack upgrade efforts
- Foster relationships and act as a technical liaison between the DBA Team and the Lines of Business
- Monitor database performance, availability, and capacity
- Participate in continuous business process redesign to improve internal operations
- Perform backup and recovery on Database Management Systems, configure database parameters and prototype designs against logical data models, and define data repository requirements, data dictionaries, and warehousing requirements
- Provide status reports that detail issues for escalation to management
- Perform configuration, scripting, analysis, installation, monitoring, administration, and tuning for database management systems
- Perform troubleshoot Service Broker queues, message flow, and stuck message flow
- Perform BizTalk SQL server support and act as SME to support message SLA
- Develop, implement, and test database backup and recovery policies and procedures
- Create and maintain documentation for database policies, procedures, and processes
- Perform/schedule routine maintenance on databases to keep them running at peak performance
- Review database storage utilization to ensure proper whitespace allocations
- Review and develop trend analysis for incident remediation and prevention
- Interface with user departments remotely and on-site to assist in the implementation of work requests and provide operational support
- Troubleshoot issues and recommend solutions
- Research and evaluate new RDBMS for possible implementation