SUMMARY

• Over 15+ years IT experience with more than 11+ in Database Administration, System Analysis, Design, Development and Support of PostgreSQL 9.6 to 11 and MS SQL Server 2017, 2016, 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 2017, 2016, 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 Transnational.
• Knowledge of Relational Database Management systems(RDBMS).
• 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 SAP Business Objects 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: Power shell 1.0 to 5.0, VB (5.0 6.0), SQL, VB.Net, ASP. Net, C#, C, C++ and VBA

Operating Systems: Windows (2016, 2012 r XP NT 3.x- 4.0 2008 r2) and Unix.

Databases: PostgreSQL (9.6, 10, 11), MS SQL Server (2017, 2016, 2014, 2012, 20 7.0 ), MS Access, FoxPro, Oracle 8/9HA + DR: Amazon RDS Aurora Clusters, Windows Clusters, SQL Clusters, Always On 2017, 2016, 2014, Mirroring, Replication, Log Shipping, 3rd Party Replications.

AWS: AWS Cloud Services, EC2, S3 storage, EBS volumes, AMI, RDS (PostgreSQL, SQL Server and MySQL)

DB Backup Tools: SQL Lite Speed, Commvault, Red Gate, Symantec Backup Exec 10, to 2010, SQLFTP Backup

Business Intelligence Tools: SAP 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, 2012,2014,2016 & SAP Crystal Report

DBA Tools: Idera SQL DM, SQL Sentry, Dell Change Auditor, SQL Advantage, Erwin, DBArtisan, TOAD, Backup Utility, SQL Light Speed, MS Visio, Solar Winds, Fog light, Ignite DPA, SCOM, PGAdmin . Dbeaver ..

Development Tools: Visual Studio 7.0,2000, 2003, 2005,2008, 2010

ERP: Oracle Hyperion & Shipnet

Version Control: Visual Source Safe, SVN, Micro Focus and TFS 2010, GitHub

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Automation: Devops, Power shell, VB, C#, SQL

ETL: SSIS, Custom ETLs using SQL and Power shell

VMWare: vSphere 6.5

PROFESSIONAL EXPERIENCE

Confidential, Lathrop, CA

Sr Database Administrator

Responsibilities:

• Database administration and engineering for multiple production, QA and Development databases in distributed database environments supporting both OLTP and OLAP systems across multiple platforms.
• Strong knowledge and experience in Power shell automation for database administration, maintenance and monitoring,
• Work with Engineering / Development and CSS Operations teams to deliver and support new and existing PostgreSQL and SQL Server database systems.
• Responsible to suggest best practices in PostgreSQL and SQL Server database administration and introduce innovation with automation.
• Responsible to provide high availability database solutions using VMWare and AWS Infrastructure solutions.
• Strong understanding and experience building VMWare, Always-On Clusters, SQL Clusters and Amazon RDS Aurora Clusters.
• Maintain all database environments with multiple PostgreSQL, SQL Server databases running in a Window environment/Linux in on-Prem, AWS EC2 and RDS Instances.
• Responsible for providing day-to-day support and maintenance for existing and PostgreSQL and SQL Server databases.
• Design and build database environments and solutions that are both highly available and highly performing in on-Prem and AWS Cloud.
• Assist in the administration, management, and monitoring of all PostgreSQL and SQL Server database systems.
• Responsible for proper backup and disaster recovery procedures.
• Provide better solutions for Database Architecture, Performance tuning of databases, pro-actively Identify bottlenecks and resolve them quickly.
• Update skills continuously with emerging technologies and apply them as and when needed.
• Work with developers on performance tuning, query optimization, index tuning.
• Strong experience in replication, clustering, tuning, sizing and proactive monitoring.
• Actively work with developers to solve database / application issues without compromising database best practices and work with them to promote changes to production.
• Experience with PostgreSQL and SQL Server database systems and a desire to learn new database technologies.
• Support PostgreSQL and SQL Server database in external cloud and work with various cloud providers as required.
• Rotate with other DBAs to be on call to quickly fix issues that arise in our production and non-production environments.
• Strong proficiency in PostgreSQL and SQL Server database management
• Establish enterprise level infrastructure support environment for SQL Server and PostgreSQL DBA
• Hands on Experience in setup, configuration, troubleshooting SQL Server replication
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Establish mechanisms for data backup/restore of relational databases and provide restoration services as needed
• Estimate database capacities; develop methods for monitoring database capacity and usage
• Resolve problems identified via Monitoring/Health Check
• Develop application-specific fault-tolerant distributed database mechanisms
• Database monitoring and Supporting in Production environment
• Hands On experience with relational database performance tuning
• Good knowledge of Day to Day commands of Linux/AIX Environments PowerShell Scripting for configuring DB.

Confidential, Los Angeles, CA

Sr. DBA & DBE

Responsibilities:

• Install and configure SQL Server Always on Cluster 2012, 2014 and 2016
• VMWare Technologies
• SCOM, SolarWinds, Fog light and Ignite …
• PowerShell Automation
• POC and Rollout the Latest Technologies and Tools for Systems Engineering
• POC and Implement the Latest Versions of Software’s and Upgrades for Systems Engineering
• More than 16 years of international Travel experience
• Commvault Light speed, Symantec Backup Exec.
• Experience in Data center migrations
• Experience in AWS Migrations.
• Expert Building and deploying Always on Fail over clusters 2012, 2014 and 2016 in multi datacenter failover.
• Install and configure windows fail over cluster 2008, 2008 r2, 2012, 2012 r2, 2016 & 2017
• Install and configure SQL server mirroring 2008,2008 r2,2012,2014
• Configure SQL server Logs hipping & Replications
• Experience building AWS and VMware servers
• Design and Architect HA+DR solutions for production and monitoring environments
• Develop and design, standards, policies and procedures for HA+DR solutions
• Administer and Support 6000+ production SQL Server databases.
• Develop Configuration files .in for SQL server 2000,2005,2008,2012,2014, 2016 & 2017
• Experience doing POC projects for implementing new technology and tools for Database performance monitoring and DR Replications.
• Build SQL Server 2012, 2014 and 2016 for Dev, Test, Customer Support, Hotfix, Demo, Sandbox, AEP and Production Database Environments.
• DevOps Automation
• Implementing Data Encryption Algorithms (TDE, SQL TLS, IPSEC …)
• Monitor SQL Servers using SCOM, Fog light and SolarWinds
• Backup and restore Databases using Veritas Backup Exec, Symantec Backup Exec, Commvault, Lite Speed and Red Gate tools
• Good Knowledge in System Center 2016, fog light and SolarWinds
• Develop scripts for automating SQL Server builds
• Providing day to day operational and engineering support to the Tech Ops, System Engineering Team.
• Automate OS level optimizations for all SQL Server builds
• Develop and validate scripts using PowerShell and SQL to apply post customizations for all SQL server builds
• Troubleshoots and debugs to identify root cause of database and server failures.
• DBA’s are called upon to provide subject matter expertise when new products or contracts are being considered. Participates/influences on corporate projects and initiatives regarding Database Management.
• Design and build highly available and high-volume relational databases
• Perform backups, restores, and recovery models as needed
• Plan, prepare, test and perform database patches and upgrades
• Implement operational automation and monitoring using scripts and SQL jobs
• Performance tune and write code for database data manipulation
• Developed configuration files (configuration.ini) in SQL Server 2008, 2012, 2014 & 2016 for silent installations and infrastructure builds
• Develop SQL and Power Shell scripts for AWS Devops automation
• Experience with AWS Cloud Services, AMI, AWS EC2, AWS S3 Storage, AWS EBS Volumes, Snapshot Backups, AWS RDS
• Develop and validate configuration parameters required to complete the SQL Server Image 2012,2014 and 2016 applicable to specific version, server, application and environments
• Automated prepare and complete image SQL Server 2008, 2012,2014 & 2016
• Automated SQL server 2012,2014 and 2016 silent installations using configuration files and PowerShell scripts
• Installed and configured windows failover cluster 2008 R2 and 2012 R2
• Test POC for SQL Server 2012, 2014 and 2016 HADR windows failover clustering Always on availability Group 2 node cluster Asynchronized commit manual failover
• Can Learn the New Technologies quickly and Implement
• Install and configure Mirroring, log shipping & replication.
• Automated maintenance jobs, configure alerts using Idera DM, Configure SQL Alerts …
• Architect, Develop, standards, policies, procedure for automaton, GUI and command line interface to build infrastructure for various database and application environment
• Prepare Architecture, designs and present the design and solutions to the team & managers
• Develop, test and implement scripts to backup and restore SQL Lite speed
• Very Good knowledge and experience working with all features in SQL Server 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014 & 2016 databases
• Installing, monitoring, maintaining, upgrading, and tuning databases supporting a network of web sites/business units.
• Performance optimization, rewriting queries, introducing indexes, tables partitioning and schema maintenance.
• Implementing secure database installations with least privilege access.
• Implementations of backup and disaster recovery solutions.

A+E Television Networks, New York, NY

Lead DBA & Architect

Responsibilities:

• Install, configure and maintain SQL Server database servers, analysis servers, jobs servers, monitoring server, Clustering, Always On, Log Shipping,
• Worked on preparation, plan, design, implement Database migration from on-Prem to AWS cloud and Virtualization environment for about 380 servers
• Developed configuration files (configuration.ini) in SQL Server 2008, 2012, 2014 & 2016 for silent installations and infrastructure builds
• Develop SQL and Power Shell scripts for AWS devops automation
• Experience with AWS Cloud Services, AMI, AWS EC2, AWS S3 Storage, AWS EBS Volumes, Snapshot Backups, AWS RDS
• Develop and validate configuration parameters required to complete the SQL Server Image 2012,2014 and 2016 applicable to specific version, server, application and environments
• Automated prepare and complete image SQL Server 2008, 2012,2014 & 2016
• Automated SQL server 2012,2014 and 2016 silent installations using configuration files and Power Shell scripts
• Installed and configured windows fail-over cluster 2008 R2 and 2012 R2
• Test POC for SQL Server 2012, 2014 and 2016 HADR windows fail-over clustering Always on availability Group 2 node cluster Asynchronized commit manual failover
• Install and configure Mirroring, log shipping & replication.
• Automated maintenance jobs, configure alerts using Idera DM, Configure SQL Alerts …
• Architect, Develop, standards, policies, procedure for automaton, GUI and command line interface to build infrastructure for various database and application environment
• Prepare Architecture, designs and present the design and solutions to the team & managers
• Develop, test and implement scripts to backup and restore SQL Lite speed
• Very Good knowledge and experience working with all features in SQL Server 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014 & 2016 databases
• Troubleshooting/performance tuning skills to improve SQL performance.
• Expert level of SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.
• Experience with very complex database environments.
• Experience in working controlled environment, change control, and validated systems.
• Good experience virtualization
• Experience working with SQL Lite speed, Idera SQL DIAGNOSTIC Manager, SQL Sentry and Dell Change auditor
• Provide solutions for High availability
• Good experience with PowerShell automation & PowerShell development
• Developing and scheduling database maintenance
• Auditing policies and security
• Maintain highly available database using Microsoft Always On technology
• Building and automating Microsoft SQL database servers in AWS (Amazon Web Services)
• Creating user accounts and granting access to users
• Developing SQL scripts, stored procedures, triggers, views, etc.
• Developing and maintaining data migration processes
• Performance tuning SQL queries and database processes
• Assist in other database related tasks as needed

Confidential, New York, NY

Sr Oracle & SQL Server

Responsibilities:

• Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R 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 .
• 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.
• Experience with AWS/Cloud Services, AMI, EC2, S3 Storage, EBS Volumes, Snapshot Backups
• 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.

Confidential

Marine IT - Database Administrator

Responsibilities:

• 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 .
• 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.
• SQL Server Migration Assistant for DB2 - SSMA (DB2ToSQL)
• Installing SSMA for DB2 (DB2ToSQL)
• Configure SSMA Console through the script files. For more information on this section, see Creating Script Files (DB2ToSQL) .
• Creating Variable Value Files (DB2ToSQL)
• Creating the Server Connection Files (DB2ToSQL)
• Executing the SSMA Console (DB2ToSQL) based on your project needs
• Managing Passwords and export/ import it onto other Window machines
• Generating Reports to view the detailed xml output reports for assessment /conversion and data migration. Detailed error reports can also be generated for refresh and synchronization commands.
• Familiar with GUI features in SSMA for DB2 (DB2ToSQL)
• Connect to an DB2 database.
• Connect to an instance of SQL Server.
• Convert DB2 database objects to SQL Server syntax.
• Load the objects into SQL Server.
• Migrate data from DB2 to SQL Server.

Confidential

S r Software Engineer

Responsibilities:

• 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.