SUMMARY

• 8+ years of SQL Database Administration experience.
• Well versed in all phases of System Development Life Cycle (SDLC) including analysis, design, programming, implementation and maintenance of stand - alone software services with special focus on database application and windows administration.
• Played a SME (Subject Matter Expert) role for 5 applications and supported/managed the offsite team.
• Proactive in identifying the risks and issues for the applications and determined the solutions well in advance.
• Expert in DB Migrations and SSIS Migrations too.
• Solely handled the tasks in Data Center Migration from initial documentation, till the successful completion report.
• Closely worked with the end customers and internal customers and received many appreciations and Kudos from them.
• Extensive experience in MS-SQL Server Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies, Performance tuning/Query Optimization and Data Migration (CLUSTERED MIGRATION).
• Expert in data installation/maintenance/migration of MS SQL Server 2000 through 2014.
• Expert in Windows server 2000, 2003, 2008 and 2008 R2.
• Designing, testing and implementation of high availability solutions like Clustering, Database Mirroring, Log Shipping, and Replication, Always On, of databases for large, medium and small customers to further increase scalability and stability of business critical systems.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Expertise in developing drill-through, drilldown reports using SQL Server 2005 Reporting Services (SSRS)
• Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages etc.
• Experience in implementing different types of Replication Models.
• Experience in writing and debugging Stored Procedures, Views and Triggers.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, C++, C#.

Database Application Software: SQL Server 7.0 through 2014, MS Access, Oracle

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

Reporting: MS Access, Excel, SSRS, SSIS, SSAS.

ETL Tools: SSIS, SSRS, SSAS, DTS.

Application Software: Confidential Office, VISIO.

Change Management Tool: Team Foundation Server (TFS), JIRA.

Scripting Language: POWERSHELL

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, 2012 Linux (Home PCs)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. SQL DBA

Responsibilities:

• Responsible for owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs.
• Efficiently handled the Database and SSIS Package Migration process from End-End and successfully completed the project with many appreciations.
• Highly involved and guided the SSIS migration plans. Starting from documentation, connectivity, architecture, and other statistics too till the completion of the project successfully.
• Reviewing service related reports (ex. Database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLA.
• Responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.
• Proficient in TSQL and well experienced in Release Management too.
• Well versed in strong documentation for processes and procedures.
• Good Experience in performance tuning, query optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention. Solid experience with windows servers, security delegation and storage components.
• Maintained a healthy relation with the team and the higher management too and received many appreciations w.r.t the work and other activities too.

Confidential, Mountain View, CA

SQL DBA/DBA DEV

Responsibilities:

• Primary responsibility is implementing, analyzing, improving, enterprise-level system architecture, DB designs, and working with one or more development teams to realize future DB architecture.
• Work with other Engineers, Managers, QA and IT/Operations teams to develop innovative DB solutions that meet market needs with respect to functionality, performance, scalability, reliability, realistic implementation schedules and adherence to development goals and principles.
• Maintenance and development of OLTP, OLAP, and data warehouse databases.
• Utilize novel approaches to solve complex technical problems and apply advanced technical principles, theories and concepts to develop innovative products.
• Replication design and maintenance including SQL Server log shipping, real-time replication, DB/Table partitioning and archiving, DB capacity planning
• Design and documentation for database backup and disaster recovery procedures. Manage and perform maintenance, backups and security for the development databases
• Advanced level database engineering support and assistance including design/implementation of distributed DBs, DB and Table partitioning, DB performance optimization etc.
• Identify, investigate, and resolve database performance issues, database capacity and scalability issues and data distribution issues.
• Review database design changes with the team to determine the impact to the physical database and other systems, and Troubleshoot Production database issues.
• Perform capacity planning and Monitor Production & Development database and SQL Server performance
• SQL scripting; performance tuning; Stored procedures, Function and trigger design and coding, Index implementation and maintenance, Database backup and recovery.
• Windows Patching to make the servers compliant.
• Enforce database standards (MS SQL Server 2008/2012) and best practices.
• Strong analytical and troubleshooting skills.

Confidential, Redmond, WA

SQL DBA/Service Engineer

Responsibilities:

• Played an SME (Subject Matter Expert) role for 5 applications supporting and managing the offsite team.
• Installed and maintained SQL Server 2005 through 2014.
• Responsible for configuration of Confidential Server/Client Products and implementation.
• Developed various T-SQL stored procedures/functions for the Application.
• Responsible for database tuning using normalization and application tuning using Query Analyzer and SQL Server Profiler
• Data migration between different environments and Third Party Databases.
• Monitored user accounts, user permissions, table partitions and backup.
• Performed database consistency checks, Backup/Recovery plans
• Experienced in windows administration environment.
• Windows Security Patching for more than 200 servers.
• Expert in Mirroring, Replication, Log shipping, Clustering, Always On, on the SQL Servers
• Worked as a Live Site engineer, which means 24/7 availability for the Application Support.
• Analyzed, Engineered and maintained the BCP Environment for very critical applications.
• Creation and management of Database maintenance plan for various database consistency checks.
• Creating monthly transaction report for all sections.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported
• Extensively Developed SQL and PowerShell scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Confidential, Middleton, WI

SQL DBA/Systems Administrator

Responsibilities:

• Systems Architect for DB migration of the core insurance backend.
• Managed Database Backups & Restoration, Backup strategies for the backend.
• Assisted with the Conversion of the legacy systems data into MS SQL server using SSIS packages.
• Developed dashboard system using MS SQL Reporting Services (SSRS).
• Data migration between different environments and Third Party Databases.
• Responsible for database tuning using normalization and application tuning.
• Implemented and maintained the DR and HA solutions i.e., Mirroring, Log Shipping, Clustering.
• Troubleshooting issues related to the SQL Production with quick and high quality.
• Windows Patching and server maintenance.

Confidential

Software Engineer (DBA/DB Dev)

Responsibilities:

• Installed and Maintained SQL Servers efficiently.
• Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Diagnostic Manager.
• Deployed the SSIS packages using manifest file in Production environment.
• Created Linked Servers between SQL server 2005/2008 and Oracle servers in the environment
• Used PerfMon and Profiler trace files to find the blocking issues, which occur as a result of I/O and CPU bottle necks and memory leaks.
• Worked on 24 /7 Production support understanding the business SLA’s.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Conversion of the legacy systems data into MS SQL server using SSIS packages.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Generated different reports using MS SQL Reporting Services (SSRS).