icrunchdata Network
Jericho, NY, USA
The Database Administrator will be responsible for collaborating with project delivery teams on analysis and development of key DB-tier stored procedures, SSIS packages, architectural components and/or infrastructure, supporting Online database environments. In addition the Database Administrator will be responsible for the day-to-day operational health, performance, availability and troubleshooting of the database tier, including but not limited to: DTS/SSIS packages, scheduled job monitoring, analyzing query plans, data archiving/pruning, application and load test benchmarks, and data-tier alerts and notifications. Provide database administration support and troubleshooting to multiple IT projects and delivery teams Work with delivery teams to analyze system capacity requirements and needs Assist in analysis, design, development, and implementation of database systems, SSIS packages, and configurations Responsible for ensuring backups of all production and mission-critical data is securely captured and restore capability enabled Work with Infrastructure team to analyze, plan and implement database upgrades Ensure that SQL developers meet the architectural standards Develop technical system documentation Configure, optimize, and support SQL Server or other relational databases Support the operation of existing applications with respect to stored procedures and database optimizations Monitoring performance, analyzing plans and facilitate performance tuning Monitoring scheduled jobs, refine and automate regular processes, track issues, and document changes Provide timely response and resolution of emergency production questions, issues and defects Resolve issues or escalate to manager, if necessary Performs database refreshes across the different environments/tiers (Dev, QA, Staging, Production) Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end Refine and automate regular processes, track issues, and document changes Required Skill/Experience: Bachelors Degree required in Computer Science or a related field 7 years of supporting online highly transactional database systems with knowledge of SQL Server 2012/2016, monitoring tools like solarwinds, New relic 7 years of supporting and managing Microsoft SQL server systems Prior experience working for an ecommerce or financial operation Experience with other relational database systems such as MySQL is preferred Experience setting up and managing clustering services for Windows systems Ability to work on-call hours on a rotational basis Strong communication skills and ability to work collaboratively in an Agile/Scrum environment - provided by Dice
The Database Administrator will be responsible for collaborating with project delivery teams on analysis and development of key DB-tier stored procedures, SSIS packages, architectural components and/or infrastructure, supporting Online database environments. In addition the Database Administrator will be responsible for the day-to-day operational health, performance, availability and troubleshooting of the database tier, including but not limited to: DTS/SSIS packages, scheduled job monitoring, analyzing query plans, data archiving/pruning, application and load test benchmarks, and data-tier alerts and notifications. Provide database administration support and troubleshooting to multiple IT projects and delivery teams Work with delivery teams to analyze system capacity requirements and needs Assist in analysis, design, development, and implementation of database systems, SSIS packages, and configurations Responsible for ensuring backups of all production and mission-critical data is securely captured and restore capability enabled Work with Infrastructure team to analyze, plan and implement database upgrades Ensure that SQL developers meet the architectural standards Develop technical system documentation Configure, optimize, and support SQL Server or other relational databases Support the operation of existing applications with respect to stored procedures and database optimizations Monitoring performance, analyzing plans and facilitate performance tuning Monitoring scheduled jobs, refine and automate regular processes, track issues, and document changes Provide timely response and resolution of emergency production questions, issues and defects Resolve issues or escalate to manager, if necessary Performs database refreshes across the different environments/tiers (Dev, QA, Staging, Production) Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end Refine and automate regular processes, track issues, and document changes Required Skill/Experience: Bachelors Degree required in Computer Science or a related field 7 years of supporting online highly transactional database systems with knowledge of SQL Server 2012/2016, monitoring tools like solarwinds, New relic 7 years of supporting and managing Microsoft SQL server systems Prior experience working for an ecommerce or financial operation Experience with other relational database systems such as MySQL is preferred Experience setting up and managing clustering services for Windows systems Ability to work on-call hours on a rotational basis Strong communication skills and ability to work collaboratively in an Agile/Scrum environment - provided by Dice