Sql Server Oracle

SOMASUNDARAM RAMANATHAN (SOMA)

Result-oriented & visionary professional with a proven record in conceiving& implementing effective ideas related to Oracle & SQL server DBA through inspiring leadership, entrepreneurial approach & innovation excellence Key Skills Profile Summary

Quality focused professional, process champion, problem solver & primary customer service leader credited with building world class services / Database Management

Installation / Patching /

Configuration /Administration /

Architecture / Replication

Storages & Data Domains

SQL Server Cluster

Oracle RAC Expertise

Application Design &

Development

Performance Tuning

Customer Satisfaction

Data Warehousing

Team Building & Leadership

Apache Cassandra, Big Data

Hadoop & MongoDB

Architecture & Administration

Career Timeline

Last 10 years

systems / processes throughout 30 years of career in Oracle, SQL Server & MySQL Database Administrator (DBA) across Production, E- Commerce, Banking and Retail domains in USA, Singapore, Africa and India Expertise in designing & driving vision, technical roadmap and short & long term directions for DBA including value proposition & functionality, mission, vision & policy formulation, budgeting / costing, strategy elements

(domain & business case), CRM, process improvement and training Enterprising leader with a strong record of contributions that conceptualized, implemented & streamlined strategies, increased business growth & profitability, delivered the suite of software products & services to global customers and enhanced internal controls:

o Ensuring policy compliance in project related documentation as per technical & functional specifications; creating documents using MS Visio Data Flow Diagrams for event driven business processes, project plans, and testing plans

o Maintaining the database performance by calculating optimum values for database parameters, implementing new releases and completing maintenance requirements

Gained hands-on experience in Oracle 6, 7, 8i OPS, 9i RAC, 10g RAC, 11g RAC & 12c RAC Database Installation, Configuration & Administration as well as SQL 2000, 2005 & 2008 R2 cluster Installation, Configuration & Administration & Informix 7, 9 & 10 Versions

Possess strong decision making skills to perceive & evaluate alternatives, analyze impact of decisions before executing them and implement them with appropriate evidence / rational

Sep’04-Mar’06:

Index Corporation

as DBA Lead

Nov’10-Apr’11: Tata

America International

Corporation as DBA

Project Technical Lead

(SQL Server and

Oracle Databases)

Education

Mar’06-Nov’10:

Alaska Airlines

as Sr. DBA

Apr’11-Jul’16:

Automatic Data

Processing (ADP) /

Cobalt Group as Sr.

Database

Administrator

Masters Degree in Science & Technology from BITS, India (University Grants Commission, Govt. of India) in 1984 Trainings / Certifications:

University of Washington (UW) Certification in SQL Server Specialist in 2007 USA Oracle 9i RAC Trained Professional – Puget Sound Oracle User Group PSOUG Certification in 2004 USA Kimball University – Dimensional Data Modeling in Depth Certification USA IPMC - Master Project Manager MPM ™ from American Academy of Project Management USA IBM Trained – Certification in IBM Informix Dynamic Server Administration USA Certifications with SimpliLearn.com, USA- Apache Cassandra, Big Data Hadoop & MongoDB Solution Architect & Administering MS SQL Server 2012 & 2014 Databases Soft Skills

Change

Agent

Communicator

Planner

Collaborator

Motivator

Notable Accomplishments across the Career

Established &supported all the database and application environments for major companies; implemented high availability to enable 24x7 service using clusters & custom standby databases scripts and configured each database based on usage (roll-backs, redolog and memory adjustments; SGA & UNIX Kernel System) Created scripts for custom replication (RPLs); executed high availability reporting system using 10g Data Guard Wrote Data Migration Scripts that could be used in any application environment where there were multiple production schemas (to be migrated) including tables, indexes, constraints, types, sequences, private & public synonyms and grants

Incorporated Database Change Control Management at Sony System in 1997 to keep track on DB changes related to Development, QA, SIT, UAT, Staging and Production System using UNIX Shell Scripting Developed:

o DBA Messaging System using UNIX Shell Scripting to centrally monitor database & page on call DBAs o OOPS (Graphical Editor GESOM to be used by Citibank for OOPS based banking system development) o Data Encryption Conversion {a tool based on Oracle PL/SQL code to move Encrypted data from Oracle encryption package called TDE (Transparent Data Encryption) to INGRIAN} Provided thought leadership & technical management in defining, implementing, ensuring, measuring & continuous improvement of DBA processes with quality standards, frameworks & practices Spearheaded large scale projects including program governance, risk management & offshore / onshore development Recipient of several awards for comprehensive accomplishment of challenging & risky situations for Airlines industry Ensured an on-going awareness of emerging developments and trends in the technology landscape through measures such as periodic software vendor interactions & end user expectations Work Experience

Apr’11-Jul’16: Automatic Data Processing (ADP) / Cobalt Group (Later CDK Global), Seattle, WA as Sr. Oracle, SQL Server & MySQL on Linux DBA

Role:

Administered Oracle database involving creation of users, setting of profile options, management of workflow, administration of new & existing concurrent manager and registration of forms & concurrent request Maintained the Oracle database performance by calculating optimum values for database parameters, implementing new releases, completing maintenance requirements &evaluating computer operating systems & hardware products Interfaced with functional business leaders in building scalable processes & metrics; leveraged the knowledge of data warehouse technical architectures, infrastructure components, data structures, Extract, Transform & Load and reporting / analytic tools & environments during execution of projects Studied the source systems & process of existing data warehouse; documented the user requirements from them, developed data models, implemented databases & wrote stored procedures Monitored project progress & outstanding issues and ensured the quality & timeliness of deliverables; extended post- implementation support to team members by defining norms Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting: o Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 o Handling Memory configurations for SQL Server 2012 on Windows 2012 Configured SQL Server with minimum privileged access Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID Troubleshoot performance problems, fine-tuning of databases and index Analysis Worked on:

o SQL Server 2008 migration from SQL Server 2005/2000 o 64 bit SQL Server 2008 / SQL Server 2008 R2 systems and MSCS configuration o Data center servers and handling 1.4 TB databases o Batch processes, Import, Export, Back-up, Database Monitoring Tools and Application support o DMV and dynamic management functions for finding out long running queries o 24 X 7 Production Database on Call Support

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

Worked on Oracle:

o Big (AIX) to small Endian (Linux) Oracle Database Migration-scripts, testing & deployment o Oracle 10g,11g &12c performance tuning

o Back-up as Database Development Lead & DB Architect o Review of various SQL codes for SQL Server & Oracle using Code Collaborator o Bug resolution with oracle SRs

o Oracle 10g, 11g 11.2.0.2 & 12c Standalone Installation & Administration o Oracle Golden Gate Replication

o Cloning & scrubbing databases from prod to pre-prod o DBA coordination between Release Management & Datafix Teams o Migration from AIX to Linux

o Oracle version upgrade & patching

o RAC 9i Decommed

o RMAN DD recovery for Oracle Automatic Data Guard in read only mode o Setting-up of RMAN DD back-ups

o Migration of MySQL databases for various applications on Linux versions o Greenplum with PostgreSQL DCA v1 & V2 support

o Oracle RAC 11g support with 5 nodes & ASM storage for DMI o Oracle RAC 11g migration with 2 nodes Oracle RAC & ASM storage for CVR project for Govt. of California o Configuration of 12c Clusterware; assisted SEs to install OEL Linux rpms & VLANs as private interconnect o Cloning of 11g home from source & copied to destination cluster nodes and read only standby & DR standby o Cluster Rolling Patch JAN, 2016 for 12c 12.1.0.2 Clusterware & Database Patch for 11g 11.2.0.4 Nov’10-Apr’11: Tata America International Corporation, USA as DBA Project Technical Lead (SQL Server and Oracle Databases); client: Boeing, Bellevue, WA Role:

Headed a team of 13 SQL server DBAs and 5 Oracle DBAs Configured 3 node 12 instance active-passive failover cluster on Windows 2008 R2 and SQL Server Version 2008 R2; applied a hot fix on top of it

Completed post install steps to verify that:

o Services were configured to log on with service account (SQL Server Services) o Instances were configured to force protocol

o Shared memory, named pipes and TCP/IP were enabled o Static fixed port number had been set-up

o Fixed amount of max* server memory was set

o Default Index Fill was 90

o TEMPDB was moved to the proper location and one data file per CPU by removing old files o Failsafe Operator or "Instancefocals" would be notified by email o SQL 2008 installation was set-up to linked server for oracle databases Assisted in configuration of SCAN Listener for Oracle 11gR2 11.2.0.2 on RHEL 5x for a 4 node RAC cluster in CAS Systems at Boeing

Resolved 150 low, medium, high and urgent priority tickets in both database types as a team Mar’06-Nov’10: Alaska Airlines, Seattle, WA, USA as Sr. Oracle, SQL Server & MySQL on Windows DBA Technical environment: Oracle 11gR2 on Clustered Nodes with ASM, VMWare Vcenter Servers, VMWare Vcenter Server Version 4.0.0 Build 20811, Oracle – 11g R1 (11.1.0.7) & R2 (11.2.0.1) 64 Bit RAC, 10g R2 RAC (10.2.0.1.0) 64 Bit, 9iR2, RAC, 8i, Parallel Server, V7, V6, V5 I, SQL Server 2008 R2 on Windows Server 2008 R2, MySQL Version 5.0.24- community-Max-Nt via TCP/IP on Windows Server 2003 4 x Intel Xeon CPU 3.4 Ghz Role:

Led procurement, deployment and maintenance of all versions of DB engines and several operating systems such as RedHat Linux 5, 4 Window Server, Sun O/s and HP-UX Itanium Headed 1 week in 3 weeks on call activities involving fixing the problems that occurred in the database Directed SQL Server 2000 to SQL Server 2005 database migration for applications like “SingleSource” involving creating a separate SQL server instance to satisfy the application functionality and “Access Control System (Lenel)” Installed &configured the following Oracle Database Systems in 11g 11.1.0.7 and upgraded to 11.2.0.1 for Data Warehouse Next Generation:

o Dev & Test Environment with Oracle ASM: Dell R900 with EMC DMX3 o QA 2 Node Oracle RAC Cluster Environment with Oracle ASM and EMC DMX3 o Production 2 Node Oracle RAC Cluster Environment with Oracle ASM and DMX3 o Oracle 11g RAC 5 Node Cluster with ASM Oracle storage capability Faced various challenges while configuring ASM in terms of sizing & configuration with EMC DMX3 Storage Unit Designed a tool based on oracle PL/SQL code to move Encrypted data from Oracle Encryption Package “TDE”

(Transparent Data Encryption) to INGRIAN

Migrated oracle databases from 10g to 11g using Data Pump & External Tables Wrote Data Pump Export Scripts for migration of data warehouse database of size 1.5 terabytes from Oracle version 10.2.0.4 on HP-UX Itanium to Oracle version 11.2.0.1 on RedHat Linux 5 environment Gained 5+ years of experience in Database Administration and Developer for very large and complex databases in SQL SQL Server 2008 R2, 2008 and 2005

Led database administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities

Gained strong technical background along with ability to perform business analysis and write effective documentation Worked on T-SQL writing stored procedures, triggers and functions Administered SQL Server High Availability and Disaster Recovery strategies Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations Worked on logical and physical data base modeling with UML and ERWIN tools Involved in clustering & server consolidation, troubleshooting production issues and raising high availability Worked on Disaster Recovery Planning and Security Management operations Gained hands-on experience in DR processes including Log Shipping and Database Mirroring Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g as well as DTS package for data transfer between two environments

Worked on Analysis Services (SSAS), Reporting Services (SSRS) and Clustering Supported very large databases (VLDB) and troubleshot the problems Rendered 24 X 7 production database on call support Sep’04-Mar’06: Index Corporation, Japan, Seattle, WA as senior oracle DBA Technical environment: Oracle 10g R2 RAC, Logical Data Guard, Oracle 9i RAC and RMAN (Database Size: 700g) Role:

Installed & configured:

o Oracle 9i RAC (9.2.0.4) 32 bit on 2 clustered servers with a gigabit Ethernet o 9i Cluster Manager, Oracle Prop. OCFS (Oracle Cluster File System) and Clustered RDBMS o Stage Cluster using Oracle 10g RAC Release R2 (10.2.0.1.0) on 2 minor 2 node cluster servers with operating system as Linux x.86 RedHat ES 3.0 {CRS (Cluster Ready Service) and Oracle RDBMS on the cluster} o 10g Grid Control on a separate server and agents on the cluster nodes o 10g Logical Data Guard on a separate server for the stage cluster to automatically move the archive logs from stage cluster and apply automatically by mining them on Data Guard Server Upgraded the memory to 8gig using 9i TAF (Transparent Application Failover) so that HA was maintained as 100% Created custom scripts to migrate schemas of SMS System to the cluster 9i RAC Utilized the migrate script to migrate schemas from Standalone Server to 9i RAC Projected for 64bit configuration of Oracle 10g for production and migrated the schemas from 9i RAC Contributed in MySQL databases on Windows 2003

Previous Experience

Feb’04-Sep’04: Boeing CDG Company (Buxton Consulting, California), Bellevue, WA as Oracle DBA Nov’01-Jan’04: Musicnet.com, RealNetworks, Seattle, WA, USA as Sr. Oracle DBA (Team Lead) Jan’97-Oct’01: Apollo Group, many cities in USA & Seattle, WA USA as Oracle DBA Mar’94-Jan’97: Sony Systems Design International, Singapore as Oracle DBA Jul’93-Feb’94: Polaris Software Lab Ltd., Chennai as Systems Manager/ Oracle DBA (consulting for Citibank) Nov’90-Jun’93: Olivetti Equatorial Ltd. (Olivetti of Italy), Nairobi, Kenya, Africa as Systems Manager / Oracle DBA (consulting for First American Bank & NAS Airport Services) Nov’88-Oct’90: Mastek Ltd., Mumbai & Chennai as DBA/Developer for Oracle/ Ingres Technical Supports Dec’87-Oct’88: Binani Metals Ltd., Mumbai, India as EDP Manager Sep’86-Dec’87: Grashim Industries Ltd., New Delhi, India as Oracle Developer / Manager Jun’85-Aug’86: Online Constancy Ltd., New Delhi, India as Programmer / Analyst / Project Leader Jun'84-Jun’85: BITS, Pilani as Asst. Lecturer

IT Skills

Hardware: NetApp & EqualLogic, VMWare Vcenter Server, Dell 3 Node Cluster Poweredge 6850 4u 8p 64g, IBM DS4400, EMC DMX3, DELL 2 Node Cluster R900 4u 8p 128g Storage EMC DMX3, Dell 2 Node Cluster 6850, Sun 880, 480&E6500, E4500/450/420/250, HP-UX, Dec VAX, DEC ALPHA, IBM-SP2 and Sun Fire 280 Cluster Operating Systems: Windows 2008 R2, VMWare Vcenter Server Version 4.0.0 Build 20811, Red Hat Enterprise Linux 5, Linux x.86 RedHat AS (Advanced Server) 2.1, Linux x86 RedHat ES/AS 3.0, Linux x86-64bit Red Hat Enterprise Linux AS/ES 4 UNIX on Solaris, VAX/VMS, NT, WIN2K, UNIX on HP-UX 11.0 and Windows 7 Databases: SQL server 2014,2012, 2008 R2 on Windows Server 2008 R2 Standalone & Failover Clusters, SQL Server 2005 & 2000, Oracle–12c (Cloud) 12.1.0.2.0 pluggable/container databases, Oracle 12c Clusterware, 11g R1 (11.1.0.7) & R2 (11.2.0.1) 64 Bit RAC, 10g R2 RAC (10.2.0.1.0), Parallel Server, V7, V6, V5 I, MySQL Version 5.0.24-Community-Max- Nt via TCP/IP on Windows Server 2003 4xIntel Xeon CPU 3.4Ghz and NGRES 6.3/6.4. PostgreSQL Languages: Transact SQL, SQL, PL/SQL, UNIX Shell, Pro*C, Pro*COBOL Embedded, Oracle XML, COBOL, Visual Smalltalk 3.1.1 with GF / ST Libraries, Visual Works 2, Database Triggers, Stored Procedures and Visual Basic Tools: SQL server SSDT BI 2014, SQL Server Management Studio &Profiler, SQL Server 2000 DTS, SQL Server 2005/2008 SSIS, Oracle 12c,11g,10g Grid Control, Oracle RMAN Back-up Tool, Oracle Physical & Logical Data Guard, SQL*Plus, SQL*Loader, IOT, SQL*Forms, SQL*NET, Foglight, Space Manager, SQL*Navigator, TKPROFF, Explain Plan, DMBS_ packages and OLAP Tools, Oracle Advanced replication, Quest Replication & Oracle GoldenGate Applications: Several Applications related to Airline Industry such as SIEBEL, AIRMAX,AIMS(Greek product), Other applications from Sabre. Single Source for Aircraft Manual of Boeing modifications publishing, TRAX airline system Applications related to Telecommunication industry such as messaging, content, games. Air Craft inventory. Financial Accounting, Portfolio Management, Cargo Analysis, Project Management, Production, MRPI, CRP, Automation, Inventory Control, Graphical Editor for Static, Object Models, Foreign Exchange & Money Market System, SAP R/3 and installation and implementation. Oracle Applications version 11.0. Exposure in ORACLE WEB based applications. Music Web distribution system. Mission critical Data warehouse system on oracle RAC 11g. Greenplum DCA V2 on PostgreSQL. Peoplesoft HR application.

.

Contact Information

E-Mail: *******@*****.***

India Landline: 011-44-42123682

Mobile No.: 011-91-709-***-****

USA Mobile Cell: 001-206-***-**** ( SMS text only at this time) Personal Details

Date of Birth: March/26/1962

Nationality: USA

Country of Birth: India

Countries Having Permit to Reside & Work: USA & India

Contact this candidate