Microsoft SQL Server DBA

Microsoft SQL Server DBA
Schaumburg, IL

Only from 5 to 7 Years (DBAs having 10+ years of experience is not required)
Desired Competencies (Technical/Behavioral Competency)
Must-Have   
•    SQL Database Administration in 2000,2005,2008R2,2012
•    Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and log shipping.
•     Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
•    SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
•    Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc
•    Strong knowledge of how indexes, index management, integrity checks, configuration, patching.
•     Able to prioritize and execute tasks in a high-pressure environment
Good-to-Have   
•    Exposure to SSIS/SSRS
•    Exposure to PostGreSQL, MySQL

SN    Responsibility of / Expectations from the Role
1    Work with client and understand the requirements
2    Work on L2 tickets and identify the L3 opportunities and handover to offshore
Handle Escalations from Team and Customer
3    Assist team in crisis situation and provide quick solution to critical issues
2    Design implementation strategy and document
3    Implementation of various oracle products in New servers
4    Enable monitoring, backup and provide transition to existing DBA team
5    Direct communication with client
Prepare status weekly/monthly status report and share with customer


Comments

Post a Comment

Popular posts from this blog

RE: Excellent Business analyst Consultant Available

Image
Dear Partner, Hope you are doing great today!    This is Vikas representing Captevo Inc. Currently, we have pool of W2 consultants available Immediately on C2C basis.    Request: please take a minute and add   vikas@captevo.com  in your mailing list for current and future requirements.    Below is  updated Resume of consultant  ' Tejaswini'  currently on bench., Please let me know if you have open requirements for them.   Tejaswini:   A highly dynamic result oriented professional with strong analytic and technology expertise with almost 7 years of experience as  Business Systems and Facets Business analyst in Health Care, Banking Industry . Possess the ability to think out of the box and develop innovative business solutions which offer maximum bu
Read more

Things to Consider When Preparing for Your Special Education Job Interview

Things to Consider When Preparing for Your Special Education Job Interview .............................................................................................................. Candidates who are seeking a job in special education face unique challenges because they need to present themselves as more than a general teacher. They need to prove they are true specialists in the education field. Principals will be looking for special education teachers who are masters in developing differentiated lessons, experts in child disabilities, advocates for students, and able to work cooperatively on a team of professional educators. When you interview for a special education job, it is likely you'll be asked many of the standard questions that are presented to all teacher candidates. This includes questions about classroom management, parent communication, technology, and your philosophy of teaching. But, you will also be faced with additional questio
Read more

Precision HotList

Dear Business Partner, Hope you are doing great today Below is the list of available consultants , looking for new project. Let me know if you have any requirement which matches my consultants !! I would highly appreciate if you can add me in to your distribution list satish@precisiontechcorp.com / satishkumar.usit@gmail.com  or reach me on  732-658-4598 Keep  posting me with your daily C2C requirements.   Technology Visa Location Relocation Business/System Analyst EAD NJ Open Business Analyst EAD NY Open Business Analyst H1-B NJ Open Salesforce BA USC NJ Open Business System Analyst USC NY NY/NJ Business Analyst
Read more