Senior Consultant

Responsibilities:
Application DBA Support

This role is primarily an Application DBA function focused on project delivery and operational support rather than infrastructure management.

Key responsibilities include:

• Database deployments
• Environment support
• User and security administration
• Performance monitoring and troubleshooting
• Backup and recovery support
• Database access and permissions management
• Ticket management and issue resolution
• Participation in project delivery activities

DBAs will act as a first point of contact for database-related issues, including:

• Locking and blocking issues
• Long-running jobs
• Data processing failures
• Missing or ineffective indexes
• SQL performance troubleshooting

• Reviewing database logs
• Monitoring CPU and storage utilization
• Troubleshooting database job failures
• Diagnosing environment issues and escalating when necessary

The role functions largely as an L2/L3 support resource responsible for initial investigation and resolution.

The team supports data warehouse development projects through:

• Reviewing code changes
• Merging code into Git Hub repositories
• Supporting development teams during implementation

• Executing database deployment scripts
• Following deployment instructions packaged through Service Now/Jira workflows
• Supporting deployments into QA and UAT environments
• Troubleshooting deployment issues

Deployment work typically represents 12 hours per day, while the majority of effort is spent supporting project teams. DBAs become actively involved as solutions progress through:

• Supporting QA environments
• Assisting with database changes between environments
• Troubleshooting integration and testing issues
• Supporting project teams throughout the delivery lifecycle

Developers primarily manage Development environments, while DBAs provide support as projects move into QA and UAT.