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 wif special focus on database application and windows administration.
• Played a SME (Subject Matter Expert) role for 5 applications and supported/managed teh offsite team.
• Proactive in identifying teh risks and issues for teh applications and determined teh solutions well in advance.
• Expert in DB Migrations and SSIS Migrations too.
• Solely handled teh tasks in Data Center Migration from initial documentation, till teh successful completion report.
• Closely worked wif teh 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 wif 24/7 production Environment wif 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 wifin SLAs.
• Efficiently handled teh Database and SSIS Package Migration process from End-End and successfully completed teh project wif many appreciations.
• Highly involved and guided teh SSIS migration plans. Starting from documentation, connectivity, architecture, and other statistics too till teh completion of teh project successfully.
• Reviewing service related reports (ex. Database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved wifin established SLA.
• Responding to database related alerts and escalations and working wif database engineering to come up wif 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, me/O, disk space and other resource contention. Solid experience wif windows servers, security delegation and storage components.
• Maintained a healthy relation wif teh team and teh higher management too and received many appreciations w.r.t teh 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 wif one or more development teams to realize future DB architecture.
• Work wif other Engineers, Managers, QA and IT/Operations teams to develop innovative DB solutions that meet market needs wif respect to functionality, performance, scalability, reliability, realistic implementation schedules and adherence to development goals and principals.
• Maintenance and development of OLTP, OLAP, and data warehouse databases.
• Utilize novel approaches to solve complex technical problems and apply advanced technical principals, 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 teh 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 wif teh team to determine teh impact to teh 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 teh 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 teh 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 teh 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 TEMPthan 200 servers.
• Expert in Mirroring, Replication, Log shipping, Clustering, Always On, on teh SQL Servers
• Worked as a Live Site engineer, which means 24/7 availability for teh Application Support.
• Analyzed, Engineered and maintained teh 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 teh 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 teh maintenance responsibility can be passed on to production support team.

Confidential, Middleton, WI

SQL DBA/Systems Administrator

Responsibilities:

• Systems Architect for DB migration of teh core insurance backend.
• Managed Database Backups & Restoration, Backup strategies for teh backend.
• Assisted wif teh Conversion of teh 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 teh DR and HA solutions me.e., Mirroring, Log Shipping, Clustering.
• Troubleshooting issues related to teh SQL Production wif 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 teh prod servers on a weekly basis using third party tool Quest Diagnostic Manager.
• Deployed teh SSIS packages using manifest file in Production environment.
• Created Linked Servers between SQL server 2005/2008 and Oracle servers in teh environment
• Used PerfMon and Profiler trace files to find teh blocking issues, which occur as a result of me/O and CPU bottle necks and memory leaks.
• Worked on 24 /7 Production support understanding teh 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 teh 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).