SQL Data Base Developer-Hybrid Remote-Charlotte NC
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
meshas@smacforce.com
512-333-5646
You received this message because you are subscribed to the Google Groups "icsc2cpositions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to icsc2cpositions+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/icsc2cpositions/CAH%2BVQfiqVUGT7qcAag9-KWXu4BUpQEzFZE3Vm_4eCGu6iQ3szQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Comments
Post a Comment
Thanks