SQL Data Base Developer-Hybrid Remote-Charlotte NC
Meru Eyana
Role: SQL Database Developer
Location: - Remote/ Partial Onsite - Charlotte NC
Infrastructure and DB Assessment & Optimization Tasks:
· Discovery Infrastructure and Databases
o Products
§ Gather information on Databases
§ Versions
§ Assigned tiers
§ Configuration(s)
§ DP/DR
§ Resources
§ RequirementSQs
§ Design standards
§ Tools
§ Monitoring configuration(s)
§ Infrastructure
§ Hardware specifications
§ Networking specifications
§ Versions
§ Configurations
§ DP/DR
§ Requirements
§ Design Standards
§ Tools
§ Monitoring configuration(s)
o Gather information on BIA
§ Define Tiers
§ Define local resiliency requirements per tier
§ Define uptime requirements per tier
§ Define DR requirements per tiers
o Gather information Databases Environment
§ Decision Matrix
§ Config Matrix
§ Tiers
§ Infrastructure
§ DP/DR
§ Roles
§ Configuration Standards
§ Reporting and Analytics
§ ETL Processes
o Tools
§ Gather information on tool used in the environment
§ Tools per environment
§ New tool process
§ Tooling standards
o Backup
§ Gather information on backup infrastructure
§ Gather information on backup standards
§ Gather information on backup decision matrix
o Monitoring
§ Gather information on monitoring tool
§ Gather information on alert configuration
§ Gather information on threshold standards
§ Gather information on alert and threshold decision matrix
o Conduct workshop on operational vision (future state goals)
· Process Efficiency
o Conduct workshop to understand ticketing process
§ Gather information on ticketing process
o Spend up to (60) hours shadowing staff
o Conduct workshop to understand BAU tasks
§ Gather information on BAU tasks
o Conduct workshop to understand project processes
§ Gather information on Project processes
o Conduct workshop to understand MACD process
§ Gather information on MACD process
o Conduct workshop on test/dev processes
§ Gather information on test/dev processes
o Gather information on alerting response actions
o Gather information on outages
§ Outages that have occurred
§ Outage resolution process
§ Resolution timelines
1. Team Dynamics
o Gather information on team Roles
§ What roles exist
§ What are needed
§ What skillsets are required
o Gather information on team Capabilities
§ What capabilities exist
o Gather information on Training matrix
o Gather information on Database Support resources
§ Cross-discipline team
o Gather information on Support Contracts
2. Design
o Infrastructure and Databases
§ Analyze database standards
§ Analyze database and infrastructure configuration for alignment with
o Best Practice
o Current standards
o Tier requirements
§ Analyze database deployment for consolidation
§ Develop gap analysis report
§ Develop remediation recommendations
§ Develop consolidation recommendations
o Process Efficiency
§ Analyze tickets for operational workflow
o Analyze up to (350) incident tickets
§ 25% Oracle
§ 48% SQL
§ 21% DB2
§ 6% Other
o Analyze up to (350) non-incident tickets
§ 15% Oracle
§ 25% SQL
§ 22% DB2
§ 5% Other
§ 33% Misc.
o Analyze BAU tasks
§ Develop operational workflow analysis and recommendations
§ Analyze existing process for efficiencies
o Develop process efficiency and remediation report
§ Analyze outages and develop outage workflow
o Develop outage workflow recommendations
o Team Dynamics
§ Analyze team roles and develop gap analysis report
§ Analyze Capabilities roles and develop gap analysis report
§ Analyze team training plan and develop gap analysis report
§ Develop gap recommendations
§ Analyze team skill and capabilities against future state vision
Develop future state gap analysis and remediation planMesha Shawn
mes...@smacforce.com
512-333-5646