Sql Server Management

SUMMARY:

Over **+ years IT experience with more than 11+ in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0 in Production, Test, Development, QA, UAT, Integration and Replication & Cluster Server Environments.

Experience in Application domain knowledge in Financial, Printing, Transport, Marine, Software, Manufacturing, Educational, Pharmaceutical, Service, Shipyard and Supply Chain, Tours & Travel industries.

Experience in installation, configuration of MS SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0 versions.

Experience working with Production 24/7 and Development Environments.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.

Knowledge of Relational Database Management systems.

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Experience with Data Transformation Services, Batch processes, Import/Export and Backup/Restore.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.

Experience in supporting Large Databases.

Hands on experience in Troubleshooting database issues.

Experience in working with Windows 2000 Advance Server and Windows NT Server – Installation and Administration.

Experience in writing and debugging Stored Procedures and triggers using T-SQL Script.

Experience in Data Modeling using Erwin Design Tool and MS Visio.

Expert skills in Seagate Crystal Reports 6.0, 7.0, 8.0, 8.5, XI

Knowledge of Networking Concepts and Object Modeling Technology.

Experience in SQL development and implementation for application development

Good interpersonal, Analytical and Communication skills and a team player

Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.

TECHNICAL SKILLS:

Languages

VB (5.0 6.0), SQL, VB.Net, ASP. Net, C#, C, C++ and VBA

Operating Systems

Windows (95 98 XP NT 3.x-4.0 200*-****-**** 7) and Unix.

Databases

MS SQL Server (2014, 2012, 2008, 2005 2000 7.0 ), MS Access, FoxPro, Oracle 8/9, DTS.

DB Backup Tools

SQL Lite Speed, Red Gate, Symantec Backup Exec 10,to 2010

Reporting Tools

BO Crystal Reports 3.0/4.0/5.0/6.0/7.0/8.0/8.5/9/10,XI Crystal Web Server, Active Reports, SSRS 2005, 2008, 2008 R2 & SAP Crystal Report 2010 to 2014

DBA Tools

SQL Advantage, Erwin, DBArtisan, TOAD, Backup Utility, SQL LiteSpeed,MS Visio

Development Tools

Visual Studio 2003,2005,2008,Ultimate Premium 2010

ERP

Oracle Hyperion & Shipnet

Version Control

Visual Source Safe,SVN,Micro Focus and TFS 2010

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

EDUCATIONAL QUALIFICATIONS:

Master’s Degree in Business Administration - M.B.A.

Certifications:

Brain bench- Certified in RDBMS Concepts, C, VB 6 System Analyst Aptitude.

Post Graduate Diploma in Computer Applications-P.G.D.C.A,

Honors Diploma in Computer Science-H.D.C.S

Diploma in Relational Database Management- D.R.D.B.M.S

Certificate Diploma In SAP Crystal Reports 2011

Microsoft Certifications:

MCSA – Microsoft Certified Solutions Associate

MCSE – Microsoft Certified Solutions Expert Data Platform

MCSE – Microsoft Certified Solutions Expert Business Intelligence

MCP - Microsoft Certified Professional

PROFESSIONAL EXPERIENCE:

NTT Data Inc Role: Sr. SQL Server & Oracle Hyperion DBA

New York, NY May 2016 to Till Date

Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 2005 and 7.0.

Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log Shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Experience in SQL Server mirroring 2005 & 2008

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Experience in SQL Log Shipping and replication

Monitor system performance with ‘Performance Monitor’ or some similar tool

Monitor Hyperion System Logs for errors and outage conditions

Troubleshoot sql server application related issues

Manage Hyperion Services for uptime

Manage Hyperion databases for uptime

Manage complete system backups

Manage or assist with management of all system RDBMS backups

Troubleshoot issues with both client and server systems

SmartView Client connections, FR Studio connections, HFM Client support

Essbase cube stop/start, HFM application start/stop,

Migration of objects between environments (Dev, Test, Production) using LCM, or manually for earlier versions

Manage the technical documentation of all fixes, versioning, and issues for the suite

Manage all technical tickets both with the internal ticketing system, and externally to Oracle or other vendors

Be prepared to apply patches to the environment including:

System level OS patches

Patches for third-party products

Patches to the product suite which may include full product reinstallations

If required by IT policy, the management of users/groups within Shared Services and their proper role assignment may be a responsibility

Understand changes in application base/scope to ensure the architecture does not need to grow

Monitor all system usage metrics so that additional hardware is expanded in advance of need: RAM, Disk, Processor, etc.

Mitsui O.S.K Lines Role: Marine IT - Sr. SQL Server DBA Sep 2011 to April 2016

Database Administration, Database Architect and Database development using MS SQL 2008 R2 to 2012.

Managed and administered 100+ databases in 70 instances.

Installed and configured a SQL 2012 clustered environment with Always-on availability group

Installed and configured a SQL 2008 clustered environment.

Installed and configured a SQL 2008 & 2008 R2 mirroring environment.

Implemented table partition in SQL 2008 and 2012

Configured and supported replication and log shipping in SQL 2005, 2008 and 2012.

Indexes strategy, Statistics Analysis, Hardware and Database Bottlenecks analysis

Analyze Top SQL executions, Wait State Analysis, Database Disaster Recovery

Backup and Recovery Operations (SQL, SQL Lite Speed, Backup Exec 10 and 2010)

T-Log Shipping, Database Mirroring, Database Configuration Management.

Experience in Installation and Configuration of SQL Server Cluster Environment, Mirroring, Environment, Replication Environment, Log Shipping Environment and Reporting Environment

Reports development using SAP Crystal Reports and SSRS 2008 R2.

SQL Server Integration Services, Ability to follow logic flow of supplied packages

Manage online data backups, local backups using Symantec Backup 2010 and the overall execution of retention policies.

Ensure documentation of entire storage and backup environment and data replication relationships are current.

Responsible for designing and engineering a stable and efficient network infrastructure as it relates to Backups.

Deployed Shipnet Fleet System across the Shore and 51 Tankers (VLCC, VLGC and LNG Vessels)

Building and Installing Shipnet Fleet servers for 51 Ships,

Building and Installing SQL server 2008 R2 for 53 servers,

Deploying and Configuring Planned Maintenance module for entire fleet for 51 ships

Deploying and Configuring Safety module for entire fleet for 51 ships

Deploying and Configuring Occurrence module for entire fleet for 51 ships

Developing and maintaining reports in SAP Crystal reports 2010

SQL Server network Configuration for Fleet and Shore servers

Configuring Outlook 2010 emails for Fleet and Shore servers

Configuring automated backup for Fleet and Shore servers

Monitor the backups for Fleet and Shore servers

Develop the crystal reports using SAP Crystal reports 2010

Developed internal portal using visual studio 2010 and Sql Server 2008 R2

Provide training for Technical and Marine Superintendents in Fleet departments and Marine Safety department

Provide training for sea farers (Captains, Chief Engineers, Chief Officer, First Engineer…) on board and shore

Go on board Ships during dry docking, bunkering, anchorage & port …to deploy, maintain and train Fleet System software

Implement crew mail system on board

Handling backups using SQL server 2008 r2

Monitoring Shore and Ship SQL Server database servers

Monitoring Shore Work Flow Agent Fleet system server in shore

Configure data replication between shore and Ship servers

Monitor data replication between shore and Ship servers.

Developing, maintaining and supporting applications using VB6 and Visual Studio 2003 to 2010.

Developed and Implemented BI environment using SSRS 2005 and 2008, Business object Crystal Reports developing & maintaining reports in Crystal reports 8, 8.5, XI, and SAP Crystal reports 2010, Aid in identifying server resources necessary to implement and maintain DBMS, Data warehouse and BI.

SembCorp Marine Role: SR. Software Engineer

Location: Singapore Jul 2010 to Sep 2011

Large production database administration experience > 5 terabyte

Experience deploying and configuring enterprise applications

Experience maintaining and supporting virtualized infrastructure

MS SQL 2008, 2005

Database Performance and Tuning

Hardware analysis (Disk I/O, Network I/O, Processors, Memory)

Raid setup analysis

Full, Diff and Transaction Log setup

Indexes strategy

Statistics Analysis

Hardware and Database Bottlenecks analysis Analyst SQL executions Wait State Analysis Database Disaster Recovery Backup and Recovery Operations T-Log Shipping Database Mirroring Database Configuration Management Database Capacity Planning and monitoring Aid in identifying server resources necessary to implement and maintain DBMS.

Monitor database growth and set up threshold to measure by.

Coordinate requests of server resources with the Network Administration team.

Capture historic growth to analyze trends and better plan for future capacity.

SQL Server Reporting Services

Troubleshooting, Scheduling.

Experience in Installation and Configuration of SQL Server Cluster Environment, Mirroring, Environment, Replication Environment, Log Shipping Environment and Reporting Environment

Reports development using crystal reports and SSRS 2008 R2 SQL Server Integration Services Troubleshooting Ability to follow logic flow of supplied packages Developed Backup and Tapes Management System using SQL Server 2008 R2 and Visual Studio Ultimate 2010, Deployed in IIS 7.

Affinity Development Group Role: SR. SQL SERVER DBA

Location: San Diego, CA Jan 2009 to Aug 2010

Configure And Build High Availability Microsoft SQL server 2005 Mirroring

Build, configure, Monitor and Maintain the Production, development, QA and UAT SQL Server for various ADG Web and windows applications

Backups - Check your backups to validate that they were successfully created per your process.

Nightly Processing - Review the nightly or early morning processes.

SQL Server Error Log - Review the SQL Server error log for any errors or security issues (successful or failed logins) that are unexpected.

Windows Event Log - Review the Application Event Log at a minimum to find out if any Windows or hardware related errors or warnings are being written.

Some of the hardware vendors write warnings to the Windows Event Log when they anticipate an error is going to occur, so this gives you the opportunity to be proactive and correct the problem during a scheduled down time, rather than having a mid-day emergency.

SQL Server Agent Jobs - Review for failed SQL Server Agent Jobs.

Monitor high availability SQL server Database Mirroring.

Performance Logs - Review the performance metrics to determine if your baseline was exceeded.

Develop, modify and implement various Application and maintenance report requirement using crystal report XI and SQL server 2005 reporting services and SQL server Integration services.

Participate in Disaster Recovery exercises, Provides technical assistance and mentoring to staff for developing conceptual and logical database design and physical database…

Support applications developed using following Microsoft Programming languages:

ASP.NET, ii. C#.NET iii. Visual Studio.NET iv.VB.NET.

Security Logs - Review the security logs from a third party solution or from the SQL Server Error Logs to determine if there is a breach or a violation in one of your policies.

Implement Centralized error handling for SQL Server at enterprise level.

Storage - Validate you have sufficient storage on your drives to support your databases, backups, batch processes, etc. in the short term.

Service Broker - Check the transmission and user defined queues to make sure data is properly being processed in your applications.

Corrective Actions - Take corrective actions based on the issues and/or errors that you found.

Improvements - Look for opportunities to improve environment based on the review and analysis performed.

Backup Verification (Comprehensive)

Backup Verification (Simple)

Windows, SQL Server or Application Updates - Check for service packs/patches that need to be installed on your SQL Server from either a hardware, OS, DBMS or application perspective.

Capacity Planning - Perform capacity planning to ensure you will have sufficient storage for a specific period of time such as for 6, 12, 18, 24, 30 or 36 months.

Fragmentation - Review the fragmentation for your databases to determine if you particular indexes must be rebuilt based on analysis from a backup SQL Server.

Maintenance - Perform database maintenance on a weekly or monthly basis.

Security - Remove unneeded logins and users for individuals that have left the organization, had a change in position, etc.

Shrink databases - If databases or transaction logs are larger, than necessary shrink those files to free up disk space.

Setup alerts for specific error levels or error messages that impact your SQL Servers in order to be notified automatically.

Setup Jobs to query for specific conditions in your tables to validate data was loaded or data is being added to specific tables based on your business processes throughout the day.

Setup notification on Job success, failure or completion.

Setup centralized error handling on a per SQL Server, application or enterprise basis then determine the business rules for specific error conditions Based on the environment and needs, build the daily, weekly and monthly checklist that is needed.

Microsoft Corporation - Live Search Club Role: MS SQL SERVER DBA - Consultant

Microsoft Corporation – LPO Role: MS SQL SERVER DBA - Consultant

Location – Sacramento, CA Jan 2007 to Jan 2009

Database administration to ensure database availability and enable the proper database monitoring.

Very good experience in Database mirroring configuration.

Developed standardized and automated release management procedures.

Managed and deployed replication server solutions supporting both disaster recovery and applications.

Excellent Experience in Development, QA, UAT, Integration, Staging and Production support.

Excellent experience in writing Stored Procedures, functions, rules and Triggers.

Able to troubleshoot, diagnose problems and recommend solutions individually and team environment.

Experience in Installing, configuring, upgrade and maintain SQL Server databases in all the Environments.

Strong knowledge in T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

Experience with MS SQL Server maintenance, backup and recovery in a VLDB environment few million transactions DB.

Excellent experience in Table and Index Partitioning.

Excellent experience in SQL Server Versions 6/0,6.5,7.0,2000 and 2005.

Good experience in SQL Server replication and clustered environment.

Experience in troubleshooting and resolving database problems.

Experience in tuning database and its objects. Very good Understanding of databases indexes.

Experience with additional RDBMS (Sybase, MS Access, DB2 and Oracle)

Experience in maintaining data and data distribution in all production and non-production databases and replication servers.

Designs and implements database back up, recovery, archiving, and conversion strategies for physical databases.

Manages Capacity Planning; Change Management of database objects; Performance Monitoring and Tuning; SQL Analysis; Security Administration.

Participates in Disaster Recovery exercises, QA Stress tests and testing and reporting during hardware/software upgrades Provides technical assistance and mentoring to staff for developing conceptual and logical database design and physical database Conducts application and server performance tuning to improve database performance

SQL Server availability monitoring, Performance tuning, Database maintenance & security.

Maintenance of jobs, DTS and SSIS packages, Capacity planning, Data integrity, Documentation of database administration tasks and procedures.

Ability to switch tasks quickly to accommodate fluctuating DBA workload.

Experience in supporting applications developed using following technologies: I. ASP.NET, ii. C#, iii. Visual Studio.NET

Experience Documenting all database standards, "best practices", policies and procedures, Ensure all database environments (Development, Staging, QA, Integration, UAT and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.

Experience Work with Developers in troubleshooting application and database issues.

Involved in the Database Design/Modeling of new applications and database changes to existing applications.

Work closely with development team to optimize schema and performance as well as standardize the use of services provided by Microsoft SQL Ensure standards and best practices used in database development are followed and maintained.

State Of California – Department Of Public Health – SFO Role: MS SQL SERVER DBA (Consultant)

Location: San Francisco, CA May 2006 to Jan 2007

Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.

Expert operational DBA for Microsoft SQL Server 7.0-2000 including database management, security, tuning & maintenance.

Expert in Scripting, Stored Procedures, MS SQL, T-SQL & Replication

Implement, Maintain & Tune all Production Databases.

Recommend hardware, software, and database solutions & configurations contribute to both strategic and tactical planning in consideration of corporate goals and objectives Develop, establish, and maintain overall database standards, processes, and related documentation Test and Implement new Microsoft SQL 2005 Servers Technologies with Cluster Technology.

Experience in (24x7) production environment carried a Pager on a regular basis.

As a member of the Management Information System Department, responsible for maintenance and to help ensure high availability of a 24X7 Production database system. Day-to-day duties include helping various Departments like Billing, CBHS, MH, and FM … with release deployments and running production scripts for defect resolution.

Work with various Departments like Billing, CBHS, MH, FM … to run scripts during release development and testing.

Ensure databases in all environments get backed up successfully.

Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.)

Monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.

Able to work in a team-oriented environment and as a member of the production support team.

Good experience with Backup & Recovery, Security, Performance monitoring and tuning.

Experience in Downloading data from Clinician Gate Way and Billing Information System to Data warehouse SQL Server on Daily, Weekly and Monthly Basis.

SembCorp Marine Role: Server Developer/DBA

Location: Singapore Aug 2001 to May 2006

eHR Integrated Information System.

Drawings Management System Library Information System

Vehicle Tracking and Maintenance System

Change Alert Information System Builder Furnished Equipment (BFE) Owner Furnished Equipment (OFE)

eLeave Information System

Responsibilities:

Performed migration of servers from SQL Server 7.0 to 2000; analyzed the entire system prior to migrating.

Used Normalization techniques for designing database applications using SQL Server 2000.

Implementation of an enterprise management application and its supporting Microsoft SQL Server 2000 database. Responsibilities included attending team meetings database analysis and design as well as data mapping for a conversion from a legacy flat file database to a relational database

Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity and defaults and rule.

Security Administration: Included creating various user groups and assigning the accessibility according to requirement, monitoring the user accounts, creating user accounts, granting the privileges to users and groups.

Monitoring all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.

Performed regular database backup and recovery operations.

Resolved database performance capacity replication and other distributed data issues.

Significant stored procedure development utilizing SQL Server 2000. Responsible for 24X7 on-call rotation.

Created custom DTS packages using Visual Basic, and custom data transfers

Within DTS I have used multiple drivers from OLE/DB to native to 3rd party developed drivers and of course ODBC.

Designed and implemented support for multiple larger size databases

Developed a clustered environment (active / passive) to further increase scalability and stability of business critical systems.

Used BCP to import and export license data to and from SQL Server database.

Created DTS packages to export data from SQL to Excel and Word for license subscription reporting purposes.

Setting up SQL Mail. Installing and Implementing OLAP services for the existing established database.

Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.

Design and development of web pages using ASP.NET, ADO.Net and HTML.

Used Visual Source Safe for Configuration Management and Version Tracking.

Interaction with programmers and fulfill their requirements.

Used different environment included Development, Staging, Testing, and Training & Productions for Implementations.

Environment: SQL Server 7.0/2000, Windows 2000, UNIX, .Net Framework, VB.Net, ASP. Net, C#, VB 6, Crystal Reports 8.5/9/10 and Excel Macros.

Contact this candidate