OBJECTIVE:

• Highly dedicated Database Administrator who has vast experience and understanding of managing enterprise databases with strong verbal and written communication skills seeking challenging position with an innovative and fast growing organization.

SUMMARY

• Professional experience of high available technology, like Cluster, AlwaysOn, Mirroring, Replication and Log Shipping.
• SQL Server installation and configuration for application specific requirement.
• Performance tuning with SQL SentryOne, Idera, fog light and SQL and system monitoring with MOM and SCOM
• Database migration from legacy application with upgrade, using data transfer tools
• Used DMVs, triggers and system procedures for troubleshooting as well as different third - party monitoring tools.
• Extensive performance tuning experience, specializing in instance tuning and SQL optimization.
• Extensive experience with designing and implementing SQL Server databases, including systems and database architecture, project management, implementation and tuning.
• Experience working with Windows NT/ 2000/2003/2008 R 2/2012/2014/2016
• Strong team player with great verbal, written communication and interpersonal skills
• Ability to prioritize and complete multiple tasks and detail oriented
• Proven capability to approach problems effectively and creatively in complex environment
• Quick learner, take initiative, and hard worker
• Install and configure SSRS features for Native Mode, share Point and Custom requirement.
• Create and schedule report jobs to fetch report data for reporting sites.
• Create, simple SSIS packages and review complex packages created by developers before deployment.
• Migrate SSIS packages from legacy to higher version.

TECHNICAL SKILLS

• SQL 2000, SQL 2005, SQL Server 2008/2008r2, SQL 2012& 2014, 2016, XMLEnterprise Environments, SQL Profiler, Clustering, AG, SSIS, SSAS, SSRS, IIS, .NET Framework 4.5, EMC DDBoost, BUR, SCOM, SQL Sentry, HP SiteScope, HP ITSM, BMC Remedy, ServiceNow, Microsoft Office suits 2010/2013
• Windows Server NT/ 2000/2003/2008 /2008R2/2012R2

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Administration of SQL Server 2008R2, SQL 2012, SQL 2014, SQL 2016 and SQL 2017 providing production support for over 5000 enterprise instances.
• Extensive use of Sql SentryOne monitoring tool for database related problem diagnosis.
• Production deployment almost on daily basis.
• Responsible for Security, Replication, SSIS, SSAS, and SSRS Instances in the Production Environments.
• Implemented AlwaysOn 2012,2014 and 2016, MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node
• Responsible for the administration of AlwaysOn Instances with Synchronous and Asynchronous Secondary Replicas in Dev, Test, and Production.
• Worked extensively in automating process like creating jobs, and error reporting using Alerts, SQL Mail, and SQL Agent
• Developed and implemented comprehensive Backup plan and disaster recovery strategies
• Managed a centralized MS SQL Server 2008, 2012,2014 and 2016 Platform consisting of over 15000 mission critical databases
• Resolving requests related to database and system issues raised by user support
• Responsible for Patching, Maintenance, Backup and Recovery, Disaster Recovery (Setup and Testing), and Change Release Strategy for all customers.
• Created and maintained windows domain with 500 number of clients which is spread across multiple locations
• Planned and executed many upgrades such as Service Pack, Hot fixes etc.
• Responsible for Implementing and Maintaining Database Server Standards according to Federal Guidelines.
• Handled Fine Tuning Databases System in-coordination with Application owners to utilize the maximum resources for Database and Applications.
• Upgrade of Database from SQL Server 2008R2 and SQL 2012 to 2016 Due to Microsoft no longer supporting 2008R2.
• Migrated up to 250 servers and over 600 databases from a legacy Datacenter with upgrade to new Datacenter.
• Installed & configured database with associated database tools and performance monitoring software.
• Responsible for Research, Test, Training, and Implementation of new features of SQL Server across all the environments
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Provided optimal database file layout for utilization of storage and performance acceptable to client.
• Configured and manage SQL Server 2012 Always-On solution with 4 replicas and 2014 Always-On solution with 8 replicas.
• Participated in meetings impacting databases physical design.
• Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will own the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
• Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy in line with client disaster recovery RTO and RPO objective.
• Implemented requested refreshes pre or post restore activities (e.g. data loads).
• Database recoveries as per requirements.
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Suggested application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and worked with Change and Incidents management tools

Confidential

Consultant SQL Server DBA

Responsibilities:

• Controlled Administration of SQL Server 2005, SQL 2008R2, SQL 2012 and SQL 2014 providing production support for over 800 enterprise instances.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node
• Worked extensively in automating process like creating jobs, and error reporting using Alerts, SQL Mail, and SQL Agent
• Developed and implemented comprehensive Backup plan and disaster recovery strategies
• Managed a centralized MS SQL Server 2008 and 2012 Platform consisting of over 500 mission critical databases
• Resolving requests related to database and system issues raised by user support
• Created and maintained windows domain with 500 number of clients which is spread across multiple locations
• Planned and executed many upgrades such as Service Pack, Hot fixes etc.
• Handled Fine Tuning Databases System in-coordination with Application owners to utilize the maximum resources for Database and Applications.
• Upgrade of Database from SQL Server 2005 and 2008R2 to SQL 2012.
• Migrated up to 250 servers and over 600 databases from a legacy Datacenter with upgrade to new Datacenter.
• Installed & configured database with associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Provided optimal database file layout for utilization of storage and performance acceptable to client.
• Configured and manage SQL Server 2012 Always-On solution with 4 replicas.
• Participated in meetings impacting databases physical design.
• Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will own the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
• Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy in line with client disaster recovery RTO and RPO objective.
• Implemented requested refreshes pre or post restore activities (e.g. data loads).
• Database recoveries as per requirements.
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Suggested application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and worked with Change and Incidents management tools

Confidential

SQL Server DBA

Responsibilities:

• Developed & executed scripted changes requests in accordance with change control procedures.
• Upgrade of Database from SQL Server 2000 and 2005 to SQL 2008R2.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate approvers (if applicable).
• Conducted research and collaborated with vendor if necessary, for additional patches.
• Provided stopgap solutions if possible and acceptable by business and application team owners.
• Researched, reviewed and recommended for preventive maintenance.
• Set up security and access profiles and procedures for database system administrators.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.
• Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 6 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008R2.
• Provided & managed support to Environment of more than 800 Database Servers.
• Proven ability to handle database of more than 1 TB in Size.
• Expertise in MSSQL SERVER Database Administration.
• Configured and managed multi transactional replication chain on a production database.
• Set up Log Shipping, MSSQL Mail, SMTP
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc. and ensured the Availability of the Database Server in a 24X7 Environment.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed & implemented Scaling out solution with Data partitioning.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
• Monitored and modified Performance using execution plans and Index tuning
• Proactive and active performance monitoring and tuning of production databases
• Worked with application development and support teams to resolve database service requests and incidents within agreed upon SLAs
• Participated in implementation of new releases into production
• Provided on call support as needed to support operations of critical databases in a 24 X 7 environment.

Confidential

Desktop / PC support Desktop

Responsibilities:

• Developed & executed scripted changes requests in accordance with change control procedures.
• Provide tech support via phone, the internet, or in person at the office
• Diagnosed software/hardware problems, responding quickly, clearly, and resourcefully.
• Installed and Microsoft Windows Servers as well as Windows Desktop OS
• Configured and constantly maintain Windows Active Directory.
• Upgrade of Database from SQL Server 2000 and 2005 to SQL 2008R2.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate approvers (if applicable).
• Conducted research and collaborated with vendor if necessary, for additional patches.
• Provided stopgap solutions if possible and acceptable by business and application team
• Set up new user hardware such as Desktops, laptops, iPhones, iPads, and other peripherals
• Installed printers in remote and on-site locations
• Responsible for preparing broken mobile devices for repair as well as issuing temporary devices for users
• Provide daily customer support to users by troubleshooting issues both on site and remotely for company’s other branches
• Microsoft Windows Server Administration Windows 2003/2008 /2012
• Microsoft Windows Desktop Administration /Support/Configuration Windows 95/XP/7
• AD Support/Administration for Windows 2003
• Maintain Microsoft Windows Cluster Solutions for current OS and previous OS
• RSA Remote Access and System Management for Hardware Failures
• Service Desk Incidents / Tickets, Request Support System, Change Controls for Mission Critical Server Support
• Provide Remote System Administration and Remote Site Support via WAN/VPN

Confidential

Banking Officer

Responsibilities:

• Evaluate assets and goodwill of selected entities and place a book value to ease top management decision on investment
• Work in a group of five financial analyst to investigate, asses and monitor investment interest of the company
• Follow trends in politics, economy to forecast the effects it may likely have forex and other financial indices
• Inform management on trends in foreign market and how it could affect local market and investments
• Advice management on the unit to peg foreign currency exchanges with customers depending on the result derived from analysis
• Advice management on the number of extra equities to float after the publication of the company’s year-end financial report
• Evaluate cost and value addition for building, staffing and running a new branch, and also calculate break-even and payback period
• Attend seminars and conferences on investment and forex topics to better my skills and knowledge in making better analysis on investment and forex
• Selected to represent my department and work with other department representatives to create a module that was adopted by management as the company’s vision statement.