SUMMARY

• Total 7 years of IT experience with 3+ years of SQL Server DBA.
• Strong administration in Production Support and implementation
• Experience using SQL Server 2012/2008R 2/2008/2005/2000 , and windows server 2000, 2003 R2, 2008, 2012 R2.
• 4+ years of experience database Management System (RDBMS).
• 4+years of experience in MS SQL Installation, Configuration, Upgrading, Migration, & Maintenance of multiple SQL server environments.
• 3+ years of experience T - SQL programming skills DDL and DML.
• 3+ years of experience in T-SQL query and stored procedure. Logical and physical data modeling.
• 2+ years of experience in relational and dimensional data modeling.
• 2 + years of experience in SQL server database Encryption.
• 4+ years of experience in Database backup and restore, log shipping, scheduling the jobs and Maintenance plans.
• 4+ years of experience in Index Maintenance, Rebuilding and Reorganizing, blocking and dead lock issues.
• Creating user login roles & managing user permissions.
• 2+ years of experience in configuration & monitoring SQL Server 2012 AG cluster.
• 2+ years of experience in using and administering of SSIS and SSRS.
• 2+ years of experience in Networking with TCP/IP, LAN, WAN, BGP, Firewall and Cisco router routing and maintained connectivity.
• Working knowledge of Windows Server Administration, Active Directory.
• Experience in providing Production Support for 24x7.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000,2005,2008,2012 Linux/Unix

Database: Ms SQL server 2000,2005,2008,2012 And Oracle 11g

Database Tool: SSMS, SSCM, SSUA, SQA, SSP, DETA, DTS, SSIS, SSAS, SSRSThird Party Tool: Red Gate, Spotlight, Nimsoft.

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential - Richardson, TX

Responsibilities:

• Installation, Configuration, upgrade SSIS, SSRS and MS SQL server 2008/2012.
• Involve in Data Migration from SQL 2008 to SQL 2012.
• Creating and Maintain physical & logical database consistency.
• Create and Manage databases and logins with permissions in SQLServer2008&2012 as per the developer's request.
• Develop maintenance plan for backup and restore per request (SQL Native Tool and Red Gate).
• Troubles hooted real time production issues,(SQL Native tool and Sport light) database security issues, space issues, integrity issues, CPU, Memory, I/O disk issue, Blocking and Deadlocking issues, Network connectivity issues,
• Implemented and Maintained Transactional and Snapshot Replication for reporting purposes
• Monitor backup jobs, also make sure that all process related job and check backup failure alerts.
• Configuring and Maintaining Log-shipping, Mirroring in SQL 2008/2012server.
• Involve in configured and monitoring SQL server 2012 AG Cluster.
• Deployed SSIS packages on production server. Debugged and trouble shoot SSIS job related issue.
• Confirm all server and database are up and running fine.
• Support for multiple large database in production, development and test instance environment for various type of database.
• Provide 24X7 on-call support for any database related issue emergency RFC.

Environment: SQL Server 2005, 2008/2012, Windows R2 Server, SQL Server Agent, SQL server Profiler, DTA, DTS, TDA, SSMS, Log shipping, Mirroring, Replication, Clustering Always on 2012, R SSIS,SSAS, SSRS.

SQL Server DBA

Confidential - Jacksonville, FL

Responsibilities:

• Installed configured and maintained SQL Server 20 for managing databases
• Involved migrated MS SQL databases from MS 2005 to MS SQL 2012.
• Extensively worked on Creating user logins, groups, users, roles, database devices, databases, checking for database consistency, monitoring error logs, database space allocations, transaction log space allocations and fine tuning SQL performance.
• Maintained plan using SQL native tool and Red Gate, for database backup, index maintains & monitoring.
• Monitored and maintained performance issue, check the Locking & Blocking, Index Rebuild, Reorganize, Fragmentation, Data refresh and Memory/CPU, Disk space issues.
• Involved in Configuring and Monitoring Log shipping, Mirroring and Replication server.
• Involved in Configuring Linked servers between different servers.
• Configured &maintained all backup and log history, made sure that all process related jobs are running fine
• Created databases and logins with permissions in SQL server as per the developer's request.
• Deployed SSIS packages on production server using BI and SSMS.
• Administered SSIS server. Export & Imported data from EXCEL and flat file to SQL Server database table using SSIS export import.
• Provided 24X7 on-call support for any database related issue and emergency RFC.

Environment: Windows 2008 Server, MS SQL Server 2005, 2008, 2012 R2. ETL, SSIS,SSAS,SSRS, TDE, SQL Query Analyzer, SQL Server Agent, SQL server Profiler, Data Tuning advisor, DTS, Log shipping, Mirroring, Migration.

Assistant System Manager

Confidential

Responsibilities:

• Configured and Maintained of MS SQL Server 2000, 2005.
• Configured, and upgraded Windows Server 2003, 2005.
• Configured & Maintained windows server & Red Hat Linux, IP Sub-netting Firewall, DNS, MAIL, FTP, server
• Managed the Active Directory by adding and modifying users, assigning group rights, providing support for network drive access and resolving network account issues
• Configured and installed routing Cisco catalyst 2950/3750switch and router Series 1750/2900
• Configured Micro Tick Bandwidth manager
• Internet Security with firewall And Cisco manageable switch configuration with VPN
• Involved configured & maintained database backup & restore, Jobs, Schedules, and Log shipping.
• Created & managed the Database Users, Login & Security.
• Created Table, database objects like tables, views, indexes.
• Confirm all server and database are up and running fine.
• Provide 24X7 on-call support for any database related issue.

Environment: MS SQL server 2005/2000/ Windows 2003/ 2000 Server, SQL Query Analyzer, SQL Server Agent, SQL server Profiler, Data Tuning advisor, SSMS, T-SQL, Network, Linux, MS Excel and Windows XP