SUMMARY:

• A highly motivated professional with over six years of experience as a SQL Server Database Administrator (DBA). Detail oriented, and analytical in managing very large and highly transactional database systems.
• Takes initiative to manage and work on different projects individually and as a team. Strong business and technical vision with TEMPeffective people skills, innovative and creative problem solver, with high aptitude for learning new technologies.
• Solid working experience in designing and implementing backup/recovery solutions, setting up and managing high availability and disaster recovery solutions and developing and managing reports using SQL server reporting services(SSRS).
• 6+ years in - depth experience in managing multiple MS SQL Server 2005/2008/R2/2012/2014 servers with very large OLTP Databases in development, testing/QA and production environments while ensuring their performance, high availability and internal/external security.
• Logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
• Hands on experience in Installation, Configuration and Migration to SQL Server 2014/ 2012/2008 R2/2005, apply periodic service packs and hot fixes (cumulative updates) .
• Experience in configuring logical drives/ array and their RAID level using HP array configuration utility.
• Experience with database maintenance, management and performance monitoring third party tools including IDERA and REDGATE.
• Expertise in creating database objects and structures including databases, tables, indexes, views, snapshots, stored procedures, triggers, functions and cursors. Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
• Experience in developing complex TSQL scripts and stored procedures to perform administrative tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
• Extensive experience in performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL server profiler, activity monitor, performance monitor, event viewer, index tuning advisor, database tuning advisor (DTA), Dynamic Management views (DMV), Dynamic Management Functions(DMF),services and protocols, and configuration manager.
• Experience in using Dynamic Management Views (DMV) and Dynamic Management Functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning that include finding out long running queries and query costs.
• Experience in understanding of user management and database security at different levels to ensure database integrity and secure databases from unauthorized intrusions and data corruption.
• Extensive experience in designing, implementing and maintaining high availability and disaster recovery plans including: back-up and restore, log shipping, replication (transactional/merge), database mirroring, failover clustering and always-on.
• Expertise in automating maintenance jobs in SQL server job agent and task scheduler: such as Shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, updating statistics and full, differential and transactional log backups and other SSIS package tasks.
• Extensive experience in using Version control system tools for deploying scripts and packages.
• Experience in Extract, Transform and Load (ETL) data from heterogeneous data Sources like Oracle, MS Access, and DB2 using MS SQL Integration Service (SSIS), DTS, BCP and Bulk insert.
• Configuration and Administration of SharePoint Server 2007.
• Strong time management skills and excellent team player.
• Proficiency in object oriented Design and Architecture.
• Proficient experience with transparent data encryption(TDE).
• ER design and implementation.
• Ability to adapt quickly to changing environments.
• Excellent communication, coordination, presentation and analytical skills; worked on 24X7 Production support, involved in an on call rotation.

TECHNICAL SKILLS:

Relational DBMS: Microsoft SQL Server 2005/2008/2008 R2/2012, 2014,Microsoft Access.

Server operating systems: Windows Server 2003/2008/2008 R2.

Platforms: Windows XP/Vista/7/8/10

Development Environment: Drupal, Joomla, Eclipse, NetBeans,Notpad++

Database Programming: T-SQL, PL/SQL.

Programming: C++,VB.NET

Database modeling: VISIO 2003/2010, ERWIN.

ETL tools: MS SQL Server integration services /SSIS/, DTS.

Reporting: SAP Crystal report, SQL Reporting Service /SSRS/.

Third party tools: Red Gate, Idera.

Applications: Visual Studio, FTP, Adobe Photoshop suite, Dreamweaver, SharePoint, HTML,CSS,Vmware

Networking: VMWare, NAS, LAN, WAN, XAMP,WAMP.

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator/ Developer

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005/2008/2008 R2/2012/2014 in development, Integration, Fast Track, Load, and production environments.
• Applied Service Pack (SP) and hot fixes (cumulative updates (CU)) for Databases and Operating Systems.
• Migrated Databases from other databases like Oracle 10g to SQL Server 2008/R 2/2012/2014.
• Upgraded Databases from MS SQL Server, 2000, 2005 to MS SQL Server 2008/2008R 2/2012/2014.
• Involving in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from database designing to deployment to the production environment.
• Deployed and manage databases in development, Integration, Fast Track, Load, and production environments.
• SQL development: Experienced in developing and debugging complex SQL Queries, Dynamic Stored Procedures, User Defined Functions, Triggers, Views, Cursors, Joins, Sub-queries, CTE’s, Constraints, DDL and DML to implement the business logics.
• Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
• Creating and managing database resources, providing administration of database security including the monitoring and maintenance of user access.
• Monitoring, migrating, backup, recovery and tuning of SQL Server databases in a multi-platform environment.
• Utilize and analyze SQL Server Profiler to tune SQL Server 2008r2/2012/2014 databases.
• Detect and troubleshoot SQL server related CPU / memory, I/O, disc space and other resource contention.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and scheduling the packages using SQL Server Agent.
• Experienced in using different transformations tools like derived column, data conversion, merge, sort, union all, union, SCD, lookup, fuzzy lookup etc.
• Experienced in using different control flow tasks like data flow task, execute SQL task, file system task, FTP task, For each loop container, For loop container, Sequence container etc.
• Create documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices Data Analyst.

Confidential

SQL Administrator

Responsibilities:

• Perform daily checkups on SQL jobs, replication, hardware diagnostics for hard drives, backups, disk-space, SQL and windows error logs as part of proactive maintenance plan.
• Manage users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
• Scheduling and automating maintenance plans using SQL Server job agent.
• Set up and manage transactional log shipping, SQL server Mirroring, Fail over clustering and Transactional replication in multiple environments as part of disaster recovery plan and load balancing strategy.
• Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor and Event viewer for performance analysis and troubleshooting.
• Experienced in using DMV and DMF for performance tuning.
• Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
• Analyzing Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.

Confidential

SQL Administrator/ Developer

Responsibilities:

• Involving in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from database designing to deployment to the production environment.
• Experience in Normalization, Database design, Performance Analysis and Production Support.
• Migration of data from MS SQL 2000 and other flat files to MS SQL 2005/2008.
• Administer, maintain, develop and implement policies and procedures for ensuring security and integrity.
• Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server.
• Enrolling and mapping users following company policies and procedures.
• Design, implement, manage, schedule and automate database maintenance and disaster recovery plans.
• Configured and monitored database replication as high availability and disaster recovery strategy.
• Developed reports, Crystal Reports with T-SQL, MS Excel and Access.
• Extensively used the native tools like Index tuning wizard, Database tuning advisor, SQL profiler, Performance monitor, Activity monitor, Event viewer for performance analysis.
• Configured SMTP Server for Database Mail setup and received Alerts.
• Assisting development teams with data cleansing, migration and loading in addition to assisting and supporting development teams with reviewing, building, testing and maintaining database structures and SQL scripts.
• Website development using open source content management tools such as Joomla, Drupal.
• Installation and configuration of XAMP,WAMP for local host.
• Prepared users guide documentation.