Senior Consultant

Responsibilities:

Application DBA SupportThis 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:

Performance Monitoring

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

Operational Support

• 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.

Build and Deployment Support

The team supports data warehouse development projects through:

Build Activities

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

Deployment Activities

• Executing database deployment scripts
• Following deployment instructions packaged through ServiceNow/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:

1. Development
2. QA
3. UAT
4. Release/Deployment

Typical responsibilities include:

• 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.