SUMMARY:

• A challenging career in the IT industry as MS - SQL Database Administrator and with some oracle & Sybase & Mysql experience.
• More than 10 years of experience in the information technology having significant experience in areas of MS SQL-Server Administration in a multi-user systems involving large and distributed databases. Involved in Full Development life cycle starting with development till go live. Extensive experience with VLDB capacity 2+ terabytes of database size. Involved in migration of database from older version to the newer version. Involved in scaling the database systems including the capacity planning on Virtual systems, planning on network pipes along with High availability and disaster recovery solutions to scale, improve performance of database along with better use of hardware, network traffic etc

TECHNICAL SKILLS:

Hardware: Compaq ProLiant series (DL580), IBM (X series 350) and other Intel PC Compatibles

OS: Windows 2000/NT/98, UNIX, and Linux

Databases: MS-SQL Server (2016/2014, 2012, 2008r 2/2005/2000/7.0/6.5 ), Sybase 11/10.5, and Oracle 12.c./11g,10g, 7.x, MS-Access, MySQL

Languages: T-SQL, SQL, C, C++, Pro*C, PL-SQL

GUI: Visual Basic 6.0/5.0, ASP, Seagate Crystal ReportsOthers: SAN, Idera diag monitor, Exchange Server 5.5, IIS 4, and SMS, SQL Server Reporting services . Legato SQL Backup, VERITAS, SAP BASIS & ABAP, XML etc.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego CA

SQL Server Database Administrator + MYSQL DBA

• Database upgrade to SQL2016 or SQL2014 depends on application/vendor certification.
• Expertise in handling the windows cluster environments
• Designed and configured the Always on SQL2012 onwards
• Tuning the performance of the SQL Database including suggestion to upgrade network pipe and storage requirements
• Working closely with system engineer and network engineer to resolve the performance issue and increase productivity
• Proficient in high availability/ DR solutions like database mirroring, Replication, log shipping and snapshot
• SQL Performance Tuning and assisting developers
• Extensive experience with SSIS, developing data extract and import for the health clinic
• Extensive experience with SSRS assisting report developers for reporting
• Good experience working with database warehouse team to support the requirement from upper management (top executives) to make key decisions regards to organization
• Assisted in company database auditing and managed security efficiently
• Encrypted to secure crucial data about patient information using TDE

Confidential, San Diego CA

SQL Server Database Administrator

• Provide disaster recovery solution using ALWAYS ON
• On call support 24/7 on rotation
• Ticket handling through peregrine and tracking the system
• SQL Performance Tuning and assisting developers
• Extensive experience with SSIS, some converting from old DTS to SSIS
• Worked on database upgrades from 32 bit to 64 bit version along with upgrades
• Extensively worked on cluster environment to support high availability
• Extensively worked to upgrade cluster and provide HADR solution
• Worked round the clock with team to support our database systems
• Expert in using the RED GATE tools like database/object compare, faster deployment using SQL Data compare tool
• Worked on HP cloud / Azure, installed the DATABASE on the cloud and managed myself.
• Used Idera SQL Diagnostics manager to monitor our enterprise database servers which improves productivity
• Involved in writing the shell scripts to manage the automation

Confidential, El Segundo CA

SQL Server Database Administrator

• Routine tasks like service tickets, team and dealing with vendors
• On call support 24/7 on rotation
• Deployment of reports, migrating the reporting server
• Idera monitoring of all SQL servers
• SQL Performance Tuning and assisting developers backup and recovery using the net backup and helping the backup teams to maintain backups involved in automating the process or jobs by SQL scripts
• Maintain the SQL inventory and help management to better handle the SQL servers.
• Involved in SQL performance and turning the database by working closely working with developers and make sure we follow the standard and well documented for future reference
• Experience in SSIS packages and deployment from development environment till production environment
• Good hands on experience on SQL data warehousing for getting reports for management executives to make major decisions to improve the profitability of the organization
• Involved in Full development cycle starting from data and application design till go live
• Installed the SQL 2012 and Migrated some less critical database for evaluation and so on to live production with approval
• Installed & configured MySQL 5.7 database and managed it

Confidential

SQL Server Database Administrator

• Golden gate configuration of parameter files, extract, replicat and load balancing
• On call support 24/7 on rotation
• Deployment of reports, migrating the reporting server
• Working closely with the security team for DB user audit to ensure no potential threat to data
• Worked on closely with developers tuning the performance of procedure, query etc.
• Setup the CRM benchmark with the MS provided utility for baseline
• Involved in database designing(logical & physical) and do reverse engineering for existing DB

Confidential, CA

SQL Server Database Administrator

• Worked on closely with developers in the west coast and provide the DBA assistance
• Worked on 3rd party idera tool for sqlsafe backup & diagnostics management for sql
• Deployment of SSIS packages including the configuration files
• Extensive experience in HA & load balancing solutions like clustering, Database mirroring, replication and log shipping

Confidential, Mountain View, CA

SQL Server Database Administrator

• Working knowledge on golden gate for MS Sqlserver for High Availability using replication
• Setup the VMWARE workstation that hosts windows 2008 servers to test SQL 2008 clustering before working on production db’s
• Worked on trouble tickets to resolve day to day problem using bug and defect tracking software (remedy) and it is also called RTB (Run the Business)
• Extensively used the reporting services includes installation, configuration, security administration and management
• Extensively used the litespeed to reduce the backup time/space and object level recovery.
• On call support 24/7 on rotation
• Dealing with customers for quick resolution of database issues
• Used 3rd party tool for windows/SQL Database monitoring called Idera
• Worked on projects like data center migration of database servers.
• Expertise on data migration from source file/s including transformation /cleansing of data to sql database

Confidential, Westlake Village CA

SQL Server Database Administrator

• Expertise in monitoring the health of the database and collect useful data logs, analyze and tuned for the optimal performance
• Extensively worked on database snapshots for OLAP and reporting purposes
• Worked on trouble tickets to resolve day to day problem using bug and defect tracking software (JIRA)
• Extensively used the reporting services includes installation, configuration, security administration and management involved in writing stored procedures, trigger and design the objects based on application needs