Summary

• Highly motivated technical professional with over 10 years experience in IT and 7 years experience with relational database systems with expertise in database administration, development, modeling, programming and support
• Expertise in database administration in SQL Server using SQL Server 2012, 2008R2, 2008, 2005, 2000
• Experience in troubleshooting complex issues in a systematic manner
• Proficient in performance tuning database servers and query tuning with different tools
• Knowledge in dealing with VLDB with financial data
• Good knowledge of troubleshooting issues with CPU, memory, I/O, disk space and other issues
• Current knowledge of different backup, restore mechanisms
• Knowledge of database corruption and recovery mechanisms
• Experience in automation using PowerShell and C
• Good understanding of indexes, index management
• Highly experienced in writing advanced SQL Queries and stored procedures
• Experience in designing SSIS packages
• Certified in ITIL Foundation
• Knowledge of TOGAF architecture framework
• Knowledge of server configuration and patching
• Very proficient in creating excellent documentation for processes and procedures
• Very good customer support skills backed by years of helping clients and end users
• Experience in helping developers
• Experience in Scrum development
• Very strong understanding of relational database design concepts
• Knowledge of data warehouse dimensional modeling
• Experience in using and supporting MySQL in Windows and Linux environments
• Experience in using Oracle
• Experience in database migrations
• Experience in designing reports with SSRS and Crystal Reports
• Experience working in Sarbanes Oxley SOX compliant server environment
• Expertise in sizing out machines, benchmarking system needs and writing system specifications
• Experience in translating business requirements into technical requirements
• Experience in project management
• Experience in change management and doing root cause analysis of issues
• Experience in writing proposals, manuals and knowledgebase articles
• Very active in reading on the latest in all the SQL Server related blogs
• Team player with excellent analytical, presentation, written and oral communication skills
• Winner of multiple Employee of the month awards

Technical Skills

• Databases : SQL Server 2012/2008 R2/2008/2005/2000, Oracle 10g/9i, MySQL,
• MS Access, Teradata
• Languages : C .Net, VB.Net, ASP.Net, VB 6.0, ASP, Java
• Development Tools : Visual Studio.NET 2010/2008/2005, Adobe AEM
• ETL Tools : SSIS
• Scripting Languages : PowerShell, Python, VBScript, PHP, Perl, AutoIt
• Operating Systems : Windows Server 2008 R2/2008/2003/2000/NT, UNIX, Linux
• Reporting : SSRS, Crystal Reports, SharePoint, Business Objects XI R2
• CRM : Siebel 7.7/6.3, Siebel Analytics

Professional Experience

Database Administrator

• Morningstar Inc., Illinois
• Administered, Installed, configured, administered and secured SQL Server
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code for applications
• Monitored and tuned performance and ensured data integrity
• Managed a large number of SQL Server databases across multiple servers
• Created logical and physical relational models
• Worked extensively on modeling the Portfolio Manager systems to aggregate user securities from external brokerages
• Worked as member of the database team which is responsible for the data warehousing initiatives to provide analytics data on Morningstar.com users using SSAS and SSRS
• Created SSIS packages for ETL development
• Involved in database design including normalization
• Worked on processing and storing news feeds in database
• Monitored using BMC tools and native tools
• Experience in Change Management processes
• Participated in Root Cause Analysis for incident and created documentation with workarounds and mitigation strategies
• Worked in Sarbanes-Oxley compliant server environment
• Administered MySQL in Linux environment
• Worked on writing custom C and PowerShell programs for processing data
• Experience in Adobe CQ5/AEM content management system
• Certified in ITIL Foundation
• Knowledge of TOGAF architecture framework
• Participated in agile software development process

Environment: MS SQL Server 2008R2/2008/2005/2000, MySQL, SSIS, SQL, Visual Studio 2010, SSRS, SSAS, C .NET, Windows Server 2008R2/2008/2003/2000, Linux

Database Administrator

• Hanson Information Systems, Illinois
• Involved in extensive database design
• Managed a large number of SQL Server databases across multiple servers
• Worked on advanced SQL
• Monitored and tuned SQL server performance and ensured data integrity
• Implemented SQL Server Replication
• Migrated linked servers to connect to Oracle
• Built custom web and desktop applications for clients and internal use
• Worked with SQL Server Reporting Services
• Utilized MySQL in Windows and Linux environments

Environment: MS SQL Server 2008/2005/2000, MySQL, SSIS, Windows Server 2008/2003/2000, Linux, T-SQL, SQL Query Analyzer, Replication, VMWare ESX Server, Visual Studio 2010/2008/2005, SSRS, Crystal Reports, PHP, Linux, C .NET, VB.NET, ASP.NET, ASP, VB, VBScript

Confidential

• Office of Technology Enhanced Learning, University of Illinois at Springfield
• Administered the Blackboard and Moodle Course Management Systems
• Designed and developed web pages
• Arranged advanced technical workshops for faculty and Graduate Assistants

Environment: MS SQL Server 2005, Windows 2003 Server

Assistant Manager

• Provided Siebel Pharma and Siebel Call Center application support to Roche Pharmaceuticals
• Acquired significant training on FDA regulations, pharmaceuticals life cycle and healthcare information systems
• Coordinated Help Desk activities between C3i's Global Operations Center in Hyderabad, India, C3i's US team, the Client's Home Office team as well as other operational tiers C3i's hardware team, client's technical staff, client home office
• Worked with Networking , Software Development and Business Groups for support
• Monitored all escalations from Level I Analysts and Level II Analysts in dealing with production issues. Acted as the highest escalation point for all technical issues dealt with by the Help Desk team

Environment: Windows 2003 Server, SharePoint, Oracle 10g, Siebel 7.7, Siebel 6.3