SQL DBA - SQL Database Admin
Company Name:
The Judge Group
Job ID: 413513
Job Title: SQL DBA - SQL Database Admin
Job Type: Permanent
Company: JUDGE GROUP
Location: Voorhees, NJ
Contact E-mail:
Salary: 90k
Description:
Position: Senior SQL DBA
Location: Voorhees, NJ
Duration: Permanent
Salary: $90-105K
MS SQL Server DBA role responsible for providing operational and development database services to the organization. Primary responsibilities include owning, tracking and resolving database related incidents and requests, participation in design of database architecture for current and future products, responding to database related alerts and escalations and working with research and development teams to implement strategic solutions. Requires a heavy emphasis on performance, availability and capacity management.
Responsibilities:
- Manage, monitor and troubleshoot all production, development, and test databases.
- Perform service restoration in event of issue including working with vendors to ensure timely response to problems.
-Serve as point of contact to internal and external customers through problem resolution.
- Perform ongoing operational activities, problem management, user assistance and training as necessary.
- Monitor and ensure adequate capacity.
- Perform ongoing database and application performance tuning activities.
- Provide off-hours support as required to perform job functions and ensure service delivery.
- Gain understanding of applications that utilize databases and monitor and troubleshoot application issues that impact database performance and stability and overall service delivery.
- Perform application upgrades and patching as appropriate.
- Work with other areas of IT to troubleshoot and resolve service issues.
- Plan, design, and develop databases including schema and table layouts, underlying disk configuration, backup process, high availability and all other configurations.
- Understand customer requirements and define initial and ongoing capacity needs.
- Remain current on emerging technologies.
- Develop and test data recovery strategies and perform data restoration activities as required.
- Identify on-going improvement opportunities.
- Install and configure databases in support of design
- Perform ongoing upgrades and patches as required
- Develop, review, and support SQL code, stored procedures, triggers, etc.
- Perform production review of in house written code and assist developers in optimization and troubleshooting.
- Perform production code elevations following change management procedures.
- Understanding of security impacts of actions and adherence to company guidelines.
- Assist in development and modification of security guidelines.
- Act as advisor to internal and external customers on security issues.
- Assist in development of departmental policies and procedures.
- Define and assist in deployment of Process Improvements.
- Assist in continuous development of Support Services procedures and staff.
Requirements:
- Degree - BA / BS in Information Technology or equivalent experience
- At least 5 plus yearsa experience in MS SQL Database Administration
- MS SQL certifications a plus
- Effective team member on concurrent tasks/project management
- Excellent written and verbal communication skills
- Strong interpersonal skills a ability to communicate with all levels of customers, vendors, and IT resources
- Attention to customer service excellence and strong attention to details
- Strong analytical and troubleshooting skills.
- Develop and maintain technical and team documentation
Technology
Specific Requirements:
- MS SQL
- SQL 2000/2005/2008, 2012 is a plus
- SQL Server in a Microsoft Windows Clustering active / active and active / passive.
- SQL Server Management of SSRS, SSIS and SSAS.
- T-SQL Scripting
- SQL Server using linked server experience
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
- Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.Estimated Salary: $20 to $28 per hour based on qualifications.
The Judge Group
Job ID: 413513
Job Title: SQL DBA - SQL Database Admin
Job Type: Permanent
Company: JUDGE GROUP
Location: Voorhees, NJ
Contact E-mail:
Salary: 90k
Description:
Position: Senior SQL DBA
Location: Voorhees, NJ
Duration: Permanent
Salary: $90-105K
MS SQL Server DBA role responsible for providing operational and development database services to the organization. Primary responsibilities include owning, tracking and resolving database related incidents and requests, participation in design of database architecture for current and future products, responding to database related alerts and escalations and working with research and development teams to implement strategic solutions. Requires a heavy emphasis on performance, availability and capacity management.
Responsibilities:
- Manage, monitor and troubleshoot all production, development, and test databases.
- Perform service restoration in event of issue including working with vendors to ensure timely response to problems.
-Serve as point of contact to internal and external customers through problem resolution.
- Perform ongoing operational activities, problem management, user assistance and training as necessary.
- Monitor and ensure adequate capacity.
- Perform ongoing database and application performance tuning activities.
- Provide off-hours support as required to perform job functions and ensure service delivery.
- Gain understanding of applications that utilize databases and monitor and troubleshoot application issues that impact database performance and stability and overall service delivery.
- Perform application upgrades and patching as appropriate.
- Work with other areas of IT to troubleshoot and resolve service issues.
- Plan, design, and develop databases including schema and table layouts, underlying disk configuration, backup process, high availability and all other configurations.
- Understand customer requirements and define initial and ongoing capacity needs.
- Remain current on emerging technologies.
- Develop and test data recovery strategies and perform data restoration activities as required.
- Identify on-going improvement opportunities.
- Install and configure databases in support of design
- Perform ongoing upgrades and patches as required
- Develop, review, and support SQL code, stored procedures, triggers, etc.
- Perform production review of in house written code and assist developers in optimization and troubleshooting.
- Perform production code elevations following change management procedures.
- Understanding of security impacts of actions and adherence to company guidelines.
- Assist in development and modification of security guidelines.
- Act as advisor to internal and external customers on security issues.
- Assist in development of departmental policies and procedures.
- Define and assist in deployment of Process Improvements.
- Assist in continuous development of Support Services procedures and staff.
Requirements:
- Degree - BA / BS in Information Technology or equivalent experience
- At least 5 plus yearsa experience in MS SQL Database Administration
- MS SQL certifications a plus
- Effective team member on concurrent tasks/project management
- Excellent written and verbal communication skills
- Strong interpersonal skills a ability to communicate with all levels of customers, vendors, and IT resources
- Attention to customer service excellence and strong attention to details
- Strong analytical and troubleshooting skills.
- Develop and maintain technical and team documentation
Technology
Specific Requirements:
- MS SQL
- SQL 2000/2005/2008, 2012 is a plus
- SQL Server in a Microsoft Windows Clustering active / active and active / passive.
- SQL Server Management of SSRS, SSIS and SSAS.
- T-SQL Scripting
- SQL Server using linked server experience
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
- Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
