Vijay

SQL Server Database Administrator

Email: acxlfq@r.postjobfree.com

Mobile: +1-857-***-****

Professional Summary:

Microsoft Certified Professional in Administering SQL Server 2014.

Over 7+ years of IT experience in database administration, system analysis, backup recovery, testing, disaster recovery and development & support in production using SQL Server 2014/2012/2008R2/2008/2005/2000.

Experience in planning and implementing MS SQL server security and database permissions.

Experience in Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.

Performed database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) using native and third party tools and also Restoring on requirement

Experience in automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Managing database systems using Query Governor and Activity Monitor

Experience of using various replication models like Snapshot, Transactional and Merge replication (Planning, Replication Tools, Implementing Replication).

Provided 24/7 On Call Support for Production Databases.

Experience in implementation of SQL Server new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.

Expert working in Virtual Environment using VMWARE for SQL Server.

Migrated the Databases from an External Sybase/Oracle/MYSQL to MS SQL Database by using SSMA.

Strong in monitoring and optimizing the performance of Applications, databases, Stored Procedures, Queries and Indexes using Extended Events, Server side trace, Activity Monitor, Dynamic Management Views and Functions, Execution Plans, Performance Monitor, DBCC commands, Database Engine Tuning Advisor and other third party tools like Red Gate SQL Monitor, idera SQL Diagnostic Manager, Quest Spotlight.

Good knowledge in OOP’s concepts and Business Objects& Database analysis and design experience using Erwin.

Implementing efficient Database Design principles including Partitions and Compression techniques.

Used PowerShell script for SQL Server Maintenance activities.

Experience in Storage Capacity planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.

Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.

Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor

Expertise in Scheduling Database tasks – Jobs, Alerts, Emails, Notification.

Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards

Excellent technical, problem solving, analytical, interpersonal and communication skills.

Technical Skills

Databases:

MS SQL Server 2014/2012/2008 R2/2008/2005, SQL Azure.

ETL & REPORTING Tools:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools:

SQL profiler, SQL Query Analyzer, Index Analyzer, DTA, SQL Server Management Studio

Third Part Tools

SCOM, Idera SQL Check, Companion, lite speed, Red gate, Veritas net backup, Erwin r7, Azure Storage Explorer, Cloudberry Storage Explorer.

Languages, Back up& Monitoring

T-SQL, C/C++, Java, PERL, java script, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net, Spotlight, Red gate, Fog light

Professional Experience:

Employer: Transnational software services INC

Client: State Street Corporation, Quincy, MA July 2016 – Current Date

Role: Sr. SQL Server DBA

Responsibilities:

●High Availability Disaster Recovery during SQL 2014 migration.

●Migration of 2005 and 2008 to 2012 and 2014 Migrations.

●Production supporting DBA activities in huge OLTP environments.

●Query tuning based on High CPU, Memory and Logical reads and writes.

●Analyzing and designing and implementing different types of Replication Models.

●Supporting Huge Databases, Troubleshooting the problems.

●Extensive Oracle EBS implementation experience in multi-org environment, specifically Oracle HCM modules.

●Design & implementation of custom solutions using Agile & Waterfall mythologies in Oracle EBS.

●Spreading huge tables to different file groups to achieve maximum performance.

●Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.

●Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.

●Created ETL Process Consisting of SSIS Packages, Stored procedures, PowerShell Scripts and SQL Agent jobs.

●In Oracle EBS we monitor and track all ongoing transactions and accountings.

●Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.

●Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,

●MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.

●Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.

●Managing SQL Server using PowerShell scripts.

●Configure IIS, Install MS SQL Server and implement Software in Client Server.

●Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.

●P2V Migration of 70 + SQL servers as part of Code reduction for SQL licensing project.

●Data migration (import & export –BCP) from Text to SQL server.

●Setting up High availability always on future on new 2012 servers.

●Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data

●Encryption (TDE) and Policy based Management.

●Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces.

●Maintain the web servers (IIS) solutions deployment

●Knowledge on Azure hosting.

●Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results etc.

Environment: MS SQL Server 2005/2008/2008R2/2012/2014, Enterprise, Windows server 2003/2008/2012 64-bit, Business Intelligence Development Studio/Data Tools– SSIS, SSRS, Quest light speed and Spotlight Enterprise edition

Employer: Transnational Software services inc

Client: American Express Phoenix, AZ Jan 2016 –June 2016 Role: SQL Server DBA

Responsibilities:

Worked extensively on installation, upgrade and configuration of MS SQL Server 2008R2/2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.

Migrated from SQL Server 2000/2005 to SQL Server 2005/2008R2.

Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.

Implemented and monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.

Worked in 24X7 production support with a rotation basis.

Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.

Responsible for Physical Storage Structures and Index Design and Tuning.

Restored and recovered databases to point in time for testing, pre-prod and production environments.

Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

Used SQL Profiler to find badly performing queries and deadlocks.

Used 3rd party tools like idera SQL Diagnostic Manager in taking the backups to optimize performance and restoring.

Evaluated the peak and no peak usage pattern of the application; effectively distributed database administration activities, such as full database backup and database defragmentation during no peak hours.

Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server.

Monitored database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.

Developed SSIS packages to export data from OLTP database to OLAP database.

Involved in loading the Warehouse databases and performing maintenance tasks on these databases.

Configured and worked on SSRS in SharePoint integration and native mode.

Configured security and access as per SOX and PCI standards.

Environment: MS SQL Server 2008R2/2008/2005/2000, Windows Enterprise, Standard 2003/2008 servers, IIS Web server, Toad for SQL Server, Lite Speed, SSIS, SSRS, SharePoint, ERWIN.

Employer: Transnational software services

Client: FedEx Orlando, FL March2015 – Dec 2015

Role: SQL Server DBA

Responsibilities:

Installed SQL server 2008/2008R2 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008

Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.

Planning and implementation of database backup/restore and disaster recovery.

Analyzing business requirements and build logical data models that describe all the data and relationships between the data.

Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.

Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2

Developing SQL scripts for maintaining administration tasks.

Additionally, designed and implemented a disaster recovery system.

Configured CDC on Replicated Database.

Running Index tuning wizard and rebuilding indexes for faster query response.

Writing Stored Procedures, Functions and triggers based on the requirement.

Creating jobs/maintenance plans for Database.

Implemented MS SQL Server security policies and granted object level permissions.

Created jobs for rebuilding of indexes and updating statistics.

Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.

Performed all aspects of database administration, including data modeling, backups and recovery.

Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems.

Expertise in Security Issues such as creation and granting permissions on various Objects.

Performance Monitoring of MS SQL Server 2005/2008.

Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly

Environment: SQL Server 2005/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, Microsoft Windows 2003/ 2008R2 Server.

Employer: Transnational software services

Client: Molina Health Care, Long Beach, CA Oct 2013 – Feb 2014

Role: SQL Server DBA

Responsibilities:

Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005 on windows 2000/2003 Servers. Installation of SQL Server Service Packs & hot fixes.

Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005.

Monitoring and Troubleshooting jobs in Production, Preview and Development environment.

Scheduling SSIS jobs (SQL Agent), Converting DTS packages to SSIS packages using DTS xChange tool.

Involved in Health Check process for database and monthly auditing of the servers.

Virtualization of SQL Server in Production environment.

Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005, which includes in-place, side-by-side and standalone migration.

Implemented SQL Server high availability solutions including clustering, replication and log shipping

Worked in Active/Passive and Active/Active cluster environment.

Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).

Installed SQL Server 2005 on Active/Passive and Active/Active clusters as part of Upgrade.

Worked on different DB replication techniques.

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Designed database standards as per HIPAA and PHI specifics.

Participated in Disaster Recovery.

Participated in DR installation and troubleshooting(Mirroring, Logs hipping and High availability Cluster

Experience in T-SQL and PL-SQL

Optimized the Disk space for performance using RAID and SAN.

Worked on Performance Comparison between SQL Server 2000 and SQL Server 2005 using RML Utility tool as part of Pre-Upgrade.

Handling the RFC`s and work orders assigned to me as part of daily responsibilities.

Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.

Documented the security standards and roles depending on Development, UAT and Production environments.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.

Managing security roles in SQL Suite.

Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements

Worked on call 24/7 Support on weekly basis

Environment: MS SQL Server 2000, MS SQL Server 2005, Windows XP, Windows NT 4.0, Erwin 3.5.2, Enterprise Manager, SSIS, SQL Query Analyzer, SQL Light speed Backup Software.

Client: Innovative minds Hyd, India Oct 2009-march2013

Role: SQL Server Developer/DBA

Responsibilities:

Database Administrator, Database Programming.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

To set up SQL Server configuration settings.

Backups and Restoration of data/database using a Third Party Tool (SQL Lite Speed).

Recovering the databases from backup in disasters

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding the indexes at regular intervals for better performance

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Involved in trouble shooting and fine-tuning of databases for its performance.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance

Managing the San backups.

Gathered requirements from business users.

Wrote user requirement documents based on functional specification.

Designed physical data models.

Created functions, views and triggers.

Developed source to target specifications.

Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Deploying new code base release to UAT and Production Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing the database

Troubleshoot performance problems and fine-tuning of databases.

Involved in Index Analysis and Performance Tuning.

To analyze long running slow queries and tune the same to optimize application and system performance.

Environment

MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003

EDUCATIONAL QUALIFICATIONS:

•K.l.C.E,Vijayawada, A.P, India.

Contact this candidate