SUMMARY:

• To have a career in Database Administration with a progressive and stable organization that will utilize my functional, technical, analytical and interpersonal skills for optimal database performance and consistency. Proficient in prioritizing and completing projects and assigned tasks in accordance with budget and time schedule, yet flexible to multitask when necessary.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, index maintenance in a very large high - transaction and fast pace environment.
• Manage the production, development, and test databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Implementation of Disaster Recovery and High Availability of database servers using Database mirroring, replications, Always on, Clustering and Log Shipping.
• Round the clock production support
• Set database access and privileges for users and user groups
• Installed and Configured Active-Active Cluster environment on Window Server 2008 infrastructure Design and implement SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012 databases for mission-critical business.
• Use various 3rd party tools like SQL Toad for database and T-SQL Tuning
• Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
• Provide a support on any kind of Infrastructure changes affecting the database environments.
• Experience in monitoring and troubleshooting operations and providing on call services to clients around the clock.
• Knowledge of Disk and Server configuration through Raid for SQL Server.
• Use SQL Profiler and Extended Events for troubleshooting, monitoring, and optimization of SQL Server and SQL code
• Develop and modify stored procedures, queries, views, indexes, and functions to handle business rules, history data and audit analysis.
• Use SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools to populate data from various data sources, creating packages for different data loading operations for application.
• Monitor the daily performance of production and development environments.
• Configure and support SSIS and SSRS for SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012R2
• Troubleshoot databases and custom application issues.
• Assists in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.

AREAS OF EXPERTISE:

• Backup & Restore SQL Server Installation and Implementation
• Database Maintenance Extract Transform Loading (ETL) - SSIS, SSRS, SSAS
• Database Mirroring Log Shipping
• Database Security Performance Tuning
• Disaster Recovery Replication
• SQL Migration T-SQL

WORK EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Implement correct process for development changes to Database to store and applied when upgrading an existing system.
• Create, assign, accept and manage all incidents in BMC Remedy
• Configuring and setting up of Disaster Recovery (DR) and High Availability (HA) using Always on High Availability solutions for customers
• Design, implement and administer High Availability solutions, (clustering, log shipping mirroring and replication)
• Provide 24/7 remote support to SQL Servers on customer sites of various companies to prevent downtime
• SQL Server database physical model creation and implementation (data type, indexing, table design)
• Using SQL-Sentry and light-speed application for optimizing queries and database performance
• Setup and administering SQL Server Database Security environments using profiles, database privileges and roles to prevent data theft and increase data integrity
• Database maintenance, replication and tuning
• Migration of systems data from different databases and platforms to MS-SQL databases
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers
• Designing, Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
• Generate complex stored procedures and functions for better performance and flexibility
• Ensure database performance monitoring and tuning is regularly accomplished
• Design backup and restore strategies and Disaster Recovery solutions
• Implement security policy design for current and new applications
• Coordinate team meetings with groups for new design/strategies
• Create database design for new projects support
• Responsible for maintenance, Backup & Recovery, testing, alerts (job failures, database & server capacity, etc), and database integrity checks
• Review logs, update database statistics and index management
• Troubleshoot application performance issues, database maintenance & configuration, patching, and upgrading
• Security, auditing, configuring, documenting, enhancement & corrective changes, emergency changes
• Participate in DBA On-call monthly and document environments and processes where applicable
• Work with other DBAs and Developers team members and various application teams

Confidential

MS SQL Database Administrator

Responsibilities:

• SQL Server performance tuning and query optimization
• Managed the development, design, and implementation of new applications, as well as changes to existing hardware systems and software packages resulting in high performance for clients
• Provided remote support to SQL Servers on customer sites of various companies to prevent downtime
• Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss
• Responsible for backup & recovery policies & perform necessary database backups for all environment(DEV, QA, STAGE,PRODUCTION, SHAREPOINT)
• Running Backups in different recovery models
• Restoring backups including PITR+
• AD-HOC
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node for high availability.
• SQL Server database physical model creation and implementation (data type, indexing, table design)
• Developed, deployed and managed SSIS, SSAS, SSRS and published them for end users in SharePoint
• Set up and administered SQL Server Database Security environments using profiles, database privileges and roles.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery for high availability
• Ensured definition and development of database documentations and standards for easy continuity
• Ensured regular database performance monitoring and tuning to prevent downtime Capacity Planning for memory, Drive Space, databases / table growth trends