Occupation:Database Administrator |
Location:Des Plaines, IL |
Education Level:Bachelor |
Will Relocate:YES |
Description
About 4 years of experience as a SQL DBA. * Strong DBA skills of 24X7 Production environments. * Experience working deployment of SQL VM on virtual environment. * Installed, Configured, and administered SQL Server Reporting Services (SSRS), Developed Reports using SSRS, Deployed Reports to Report Server or share within Shared Drives, Crystal Reports etc. * Supporting customers and end users including app/web users. * Support development, test and production platforms for developing and deployment. * Developed data objects, forms and Reporting Services reports and SSIS. * Monitored and did performance tuning on indexes, queries and stored procedures on databases. * Performance monitoring and troubleshooting. * Experienced in creating technical documentations and process archiving and change management. * Strong system Administration background in Windows and Linux environments. * Troubleshoot various problems that arise in a day-to-day work and fix the issues. * Once created the database Backups, monitor those backups are being performed regularly. * Worked on improving DB performance, under high CPU & high memory situations. Also making use of SQL Server Profiler and Performance monitoring tools. * Worked with offshore team members. * Monitor database space requirements and adjust for future needs. * Ability to put up the extra effort to resolve the critical error and take the challenges, quick learner and easy adaptable to new technologies. * Perform database administration tasks as part of a scheduled change management task. * Reviewed alert logs and dump files to check for any problems related to the database. * Monitoring Hot Backup & checking log file to ensure successful Backup completion. * Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally. * In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands. * Identifies tests and resolves complex database issues (e.g., monitoring and tuning). * Defined and provided recommendations database standards, procedures and architecture. * Participated in a 24x7 production support on-call rotation. * Worked with Database tools IDERA, SQL Diagnostic manager, Sites cope for Multi Queries, Space analyzer, SQL alerts (Disk space alerts, SQL Service alerts, CPU utilization alerts). * Involved in Ensuring optimal performance and availability of databases. * Involved in creating SQL jobs and troubleshoot failed jobs. * Excellent skills in Installation, Configuration & Maintenance of SQL Server, Server Planning & Design, Exposure to Active Directory, Creating & Manipulation of data, tables, views, indexes, using SSMS & T-SQL Scripts following RDBMS strategy, Following ER Diagram as Data Modelling. * Ability to work in team and independently. * Excellent analytical communication and Interpersonal Skills.
Work Experience
| COMPANY | POSITION HELD | DATES WORKED |
|---|---|---|
| (Confidential) | Sql Database Administrator | 7/2016 - Present |
Accomplishments
Highlights:
Job Skills
Keywords
