Objective

• Years of extensive database and General IT experience.
• Would like to be part of a challenging environment where my technical skills and analytical abilities can be used towards achieving the objectives and goals of your organization.

SUMMARY

• Experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014.
• Hands on experience on DTS Packages in SQL 2000, Migration of DTS packages from SQL .
• Created & Deployed SSIS (SQL Server Integration Services) Projects, Schemas and Configured Report Server to generate reports through SSRS (SQL Server Reporting Services).
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server …
• Implemented different types of Replication Models like Snapshot, Merge and Transactional.
• Installed and maintained SQL Server 2008 R2 on production server and test servers.
• Identifying & resolving blocking and deadlocks. Experience in Schema and Data Migration Activities.
• Upgrading from SQL server …
• Installation, configuration, performance tuning, client/server connectivity, query optimization, back - up/ recovery, running Database Consistency Checks using DBCC, Data Modeling using ERWIN and Stored Procedures, Database Triggers and DTS package creation.
• Transferring users and their related passwords to new server.
• Experience in SQL Server backup and Recovery features. Experience in implementing SQL Server security.
• Configuring and Automating SQL MAIL notification.
• Expertise in Relational Database Management Systems. Extensive experience in MS SQL Server.
• Designing and documentation of SQL Server Strategies and plans.
• Automating the Database Maintenance tasks by creating Jobs and Alerts.
• Experience in working with both 32 bit and 64 bit server environments.
• Good experience with implementing DR solution, High Availability of database servers using Always ON, Replication, Mirroring and Log Shipping.
• Participated in SAN Migration, Datacenter Migrations and OS Patching as per Change Management Schedules. Strong troubleshooting and organizational skill.
• Experience in Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Extensively worked on more than Seven Terabyte Database.
• Experience in Database Backup, Recovery and Disaster Recovery (DR) procedures.
• Data migration using SSIS and DTS services across different databases like Oracle, MS access & flat files.
• Centralize all the databases and setup corresponding user security levels to make it possible for sharing the common data among different divisions.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Production and development support and responsible for maintenance of SQL Server instances.
• Installed SQL Server, 2014, 2012, 2008 R2 on Windows servers and security fix for all servers.
• Implemented Database Mirroring on SQL Server 2008/2012/2014 environments. Disaster Recovery planning and implementation - Database mirroring, Log shipping, Active Passive clustering.
• Created databases and logins with permissions in SQL Server 2008 as per the developer's request.
• Installed, Configured and deployed SSIS, SSRS and SSAS.
• Performance tuning, trouble shooting and monitored using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views (DMV).
• Creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
• Created new and upgrading existing databases from /2012/2014 servers.
• Created and managed database objects and users.
• Provided SQL Server Maintenance activities like creating and maintenance of SQL jobs, Backups and running profiler traces if required of databases.
• Provided required access for users to databases from roles and privileges.
• Implemented high availability using Replication, Log shipping and mirroring technologies.
• Assisted with examination and performance-tuning of existing SQL code.
• Worked on both active and passive Clustered environments.
• Implemented Cluster failover to passive node from active node in maintenance windows.
• Work closely with database users and application developers to provide direction and assistance in identification and resolution of user problems.
• Performed data partitioning for efficient management of database tables.
• Worked closely with developer teams to create required indexes and also removing the unused indexes.

Confidential

Database Administrator

Responsibilities:

• Upgraded Servers from SQL server 2008 to SQL server 2012 and installed service pack
• Installed and configured SQL server 2008 and administered.
• Migrated Databases, DTS packages from SQL Server 2000 to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Experience in handling the situations in change control process.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
• Administering and maintaining the company’s databases including daily monitoring and performance analysis using Statspack, ADDM, and AWR Report etc. Gathering and analyzing AWR report for troubleshooting purposes.
• Working with other IT professionals for database designs and reviews; troubleshooting database issues, and deploying timely fixes; maintaining regular and proactive database patches, updates and performance enhancement.
• Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
• Creating database that meet the constantly changing requirement and need of the company and clients.
• Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.
• Installing, patching, maintaining and upgrading all Oracle software (10g to 11g) using DBCA; Performance tuning of all Oracle Instance components and assisting the application developers in testing and implementation stages of the application tuning.
• Performing constant and occasional database backup and recovery using RMAN, Data pump Import and Export utility, multiplexing the Control file etc. Using RMAN to clone database.
• Managing and securing the database by using appropriate proper authorization schemes, roles and privileges.
• Modifying database structures as required by developers due to business or application requirements, cloning development databases for testing and training.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving. Monitor, optimize and allocate physical data storage for database systems.
• Sending daily operational report to the top management regarding the whole operation of the day, including any hitches and unusual situations.
• Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc. Provided a 24hr on call production support.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.