SUMMARY

• Database Professional highly experienced in database design, development and administration in RDBMS like Confidential, MYSQL, MS SQL Server and Oracle over more than eighteen years.
• Worked with ETL processes using complex SQL scripts, Stored Procedures in Confidential, MySQL, MS SQL Server, and Oracle and tools such as Informatica and Kettle.
• Understanding of Data warehouse concepts and Enterprise Performance Management.
• Maintenance of OLAP databases for Business Intelligence report. Excellent understanding of star schema and Snowflake schema.
• Consulting and Technical Support experience of a database product.
• Understanding of financial business processes.
• Extensive experience in UNIX shell scripting, PHP, Python, and Perl scripting.
• Excellent communication skills.

TECHNICAL SKILLS

RDBMS/Databases: Confidential, MySQL, MS SQL Server, Oracle

Other Products: Informatica Powercenter 7.0, Kettle, Oracle SQL Developer

Tools: / Software: DBARTISAN, TOAD, APT Workbench, Powerdesigner, SSH, PowerBuilder, ERWIN, FrontPage

Languages: Transact - Sql, Sql, PERL, Python, Jython, Unix Shell Scripting, J2EE (JDBC), JavaScript, XML, C, C++, Java, html, SQR

Operating Systems: Sun Solaris, IBM AIX/ RS 6000, HPUX, DEC UNIX, Windows (95/98/NT/2000/2003/ME/XP/ 2005/2008/2012 ), popular flavors of Linux including Redhat Enterprise Linux.

Application / Web Server: Confidential Enterprise Application (EA) Server, Apache, Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Senior MySQL Administration/Architect/Lead

Responsibilities:

• Providing Database services to Managed Hosting and Cloud customers from initial on-boarding to production deployment, monitoring, performance evaluation, performance tuning, capacity planning, scaling, upgrading and support.
• Managing Cloud Control Database operations on MySQL, Supporting Cloud files on Postgres which are part of backend DB infrastructure for Managed Cloud platform(MCP).
• Evaluated Gazzang encryption product for customer application and business requirement and implement the same.
• Custom monitoring requirements gathering, developing scripts to be included in a scheduled check from Nimsoft Monitoring probe setup.
• Experience in setting MySQL service using OS cluster services like red-hat cluster and native master-master and master-slave MySQL replication for redundancy, failover and failback.
• Mandatory security patches required upgrades - Followed change management and security hardening process and performed required changes and upgrades.
• Document how-to’s, processes, procedures and steps and contribute to infrastructure internal Wiki.
• Designed the database architecture and implemented for client projects.
• Developed Data Flow Diagrams, replication topography useful for Production- DR reference.
• Planned for database growth (capacity planning and scalability).
• Performed database development and implementation activities.
• Configured, tuned and maintained MySQL database servers.
• Ensured 24×7 database availability, reliability and security while in a production environment.
• Recognized and fine-tuned the database for its specific behaviors.
• Monitored running database server and performed tuning techniques.
• Ensured data integrity with good process and detected errors and misuses of data.
• Administered MySQL database installations and upgrades, performance monitoring and tuning, backup and recovery, space management, capacity planning and resource utilization.
• Researched new database technologies and methodologies.

Confidential, Dublin, California

Responsibilities:

• Installed Confidential ASE 12.5 and ASE 15.0 on centos and windows servers (2000, 2005, and 2008) and configured full auditing for use with security monitoring tools and solutions.
• Installed Confidential ASA 9.0 on Windows 2000 server and configured logging audit records to transaction log and extracting audit records to an audit trail file which is then fed to monitoring tool for custom monitoring solution for security compliance.
• Installed MSSQL server 2000/2005/2008 on Windows server 2005/2008 & configured c2 audit and traces, DDL audit and DML audit triggers and notification services integrating with monitoring solutions.

Confidential, San Francisco, California

Database Architect/Administrator

Responsibilities:

• MYSQL DBA - Install, configure, setup, administer and monitor MySQL Databases with Master/Master and Master/Slave Replication
• Database architecture - Planning and Designing databases for Vinyl’s Web sites, applications, interfaces and tools using Erwin and developing data models. Worked with the application development team on the design and prototype of revamped website and application systems to in corporate horizontal scaling using sharding with shared nothing architecture.
• Data modeling for Data Warehouse - Extended existing star schema and developed DataMart’s for reporting. Provided architecture support and management of OLAP/reporting DB instances.
• ETL Architecture - Designed and Developed ETL Processes using Pentaho Kettle to extract data from production MySQL slave servers and loading to Oracle Data warehouse. Developed Transformation with required steps incorporating surrogate and business keys and setup jobs to run the extract so that the data warehouse is updated every 15 minutes.
• ETL Administrator - Managed backups of repositories, version control and auditing. Setup monitoring using Nagios.
• ETL process maintenance- Monitored ETL process and jobs, performance tuning of ETL transformations, implement changes for ongoing maintenance and recommend enhancements for future requirements.

Confidential, San Mateo, California

Systems Engineer

Responsibilities:

• Writing, updating and maintaining Python / Jython scripts to pre-process customer’s transaction raw files, data refinement and enhancement. Then implemented merging transaction records with dimensional lookup files and aggregated measures value files.
• Setup production jobs to run these preprocessing scripts and scripts to load to proprietary database and make it available for analysis using Confidential Analyzer tool. According to customer requirements refresh of new data received and appending the same data to history partition was also implemented.
• Involved in the design and implementation of MySQL Replication configuration of Master/Slave for continued access of metadata at Amazon EC2 and in-house datacenter, implemented and documented failover and backup procedures. Previously at datacenter hosting provider system used High Available Clustered MySQL configuration and implemented backup and recovery procedures. Managed migration of metadata of the System using MySQL in a Master/Slave configuration. Optimized configuration in MySQL for best metadata access; appropriately indexed application tables and tuned sql queries for best performance. Optimized Tomcat and Apache for efficient overall system operation and access.
• Setup, Install, Configuration and Administration of Confidential software systems including metadata using MySQL 5.1 along with Apache, Tomcat and MySQL instances for feasible data processing and transformations.
• Setup, Install, Configuration and Administration of Confidential platform for QA and Staging on a hosted system, in-house and using Amazon Web Services (EC2).
• Design and implementation of partition schema using customer’s data files, metadata and customer’s required data enhancement fields like derived and aggregation fields.
• Involved in testing various upgrades of Confidential Analyzer over 3 years - A self-contained rich java client used for querying the database, doing analysis for customer-behavior and web-analytics. This also involved first designing a query tree similar to an index in a traditional relational database. The tree is built with the right combination of two fields to form a node and combination of node/field and node/node with bottom-up design to form a root node. The node can have only two leaves. Then setting up of worksheets as in queries and workbooks as in collection of queries for a report. The results can also be exported to Excel. Testing the workflow using Confidential Analyzer
• Involved in the requirements and design discussions for a web-admin tool to be used for customer user administration, defining schemas for datasets and for pre-processing, merging with dimensional lookups and data-enhanced field value lookups, loading data into database and creating instances on Amazon EC2 processing and managing inventories of volumes and snapshots. Wrote SQL for the use in web-admin for processing data including join of transaction and lookup table and data transformations.

Confidential

Application DBA

Responsibilities:

• Writing Jython scripts to pre-process Base I (Authorization transaction type records) and Base II (Clearance type transaction records). This involved data enhancement, partitioning the transaction records into regional datasets for Asia Pacific, Latin America, Europe, Middle East and USA with sampling for some regions. Previously this was done using a tool called Jobman written in visual c++ (.net framework) which allowed defining parameterized and nested jobs and tasks to run pre-processing and partitioning.
• Setup production jobs on windows 2003 servers to run these preprocessing scripts and scripts to load to proprietary database and make it available for analysis using Quaris Designer tool.
• Managed installation, configuration and administration of Quaris software system including Database, Designer and Jobman in production, staging and QA environment. Also worked and managed application support issues while business analysts used Designer for Data Quality, fraud and data interoperability analysis, QA testing and test support issues.
• Involved in development of Baseline analysis database using MS SQL server 2005 Integration services, SQL analytical functions and Data Mining. Involved in the administration of SQL server 2005 and development of ETL processes for extracting and importing data from the processed Base I and Base II load files and loading into the Baseline analysis database for use in deriving Base line numbers for fraud analysis and key performance indicators.
• Involved in the discussion of periodic schema changes and upon approval implemented the new schema in the database and setup query trees appropriately for efficient query and data access and updated all the pre-processing and partitoning scripts to accommodate the schema changes.

Confidential, LA, California

Database Engineer / Administrator

Responsibilities:

• Installation, configuration and upgrade of Confidential servers (ASE version 12.5.x, ASE version 15, Replication Server 12.6 and Confidential IQ 12.6).
• Administration of 50 Confidential ASE production database servers - Monitors and manages database backups and logs; installs, maintains and upgrades database software; restores and/or recovers data as required.
• Monitor data server performance, availability, capacity, and error handling. Responsible for data integrity, replication, security and recovery.
• Planning and Designing databases using ER diagrams and developing data models. Provide architecture support and management of OLAP/reporting DB instances.
• Involved in migrating required databases, creating and using automated scripts to load data from Confidential ASE 12.5 to Confidential IQ 12.6. Development support by creating tables, indexes, procedures and views on Confidential IQ.
• Address database integration issues including data migration, maintenance, capacity planning and new application support.
• Writing, updating and managing complex korn shell scripts to automate job-monitoring, automate backup and recovery, and job scheduling and performance statistics. Perl scripts for extracting, transforming and loading into database tables.
• Develop or approve all SQL application code to ensure efficient database access. Write stored procedures in transact SQL and ANSI SQL.
• Implemented Semantic Data Partitioning for efficient Data Extraction, Load and Purging.
• Modified backend SQL code for a Java application to use computed columns feature (similar to materialized view in Oracle).
• Monitor data usage to ensure correct use by applications and to minimize redundancy
• Designed and implemented a database replication solution for reporting.
• Set up Confidential Replication Server to support a warm standby dataserver for recovery purposes.
• Set up Replication Definitions, Replication Subscriptions, Replication Paths and Routes for Warm Standby Replicated Database.
• Set up Replication Server Manager to monitor health of Replication Servers and Dataservers in the production environment.
• Write Replication Server Recovery Procedures.
• Write scripts to monitor database connectivity and page and send emails to report issues.
• Act as liaison between database developers and business analysts. Worked closely with the application development teams to ensure correct database design and efficient application access.
• As a senior Engineer, involved in training new-hires.
• Designed the database for the web application called Accurate. This is a merchant/consumer query and survey report. Developed and implemented physical data model and wrote all the 60 + database stored procedures using transact SQL / ANSI SQL with complex business logic.
• Documented Processes and Procedures for the team.
• Provide technical expertise to the project team members on the design, development, test and implementation of online inventory application, merchant services Search engine Marketing/Search Engine Optimization systems (ecommerce).

Confidential, Dublin, California

Onsite Professional Services Consultant

Responsibilities:

• Onsite visit to Wells Fargo Bank, San Francisco, CA, to take care of the ongoing performance issue with their trading application from Confidential Inc. The application queries response time was critical for timely trades. I evaluated their hardware setup, Confidential ASE database structure, configuration, database design and physical data layout. Tested my recommended configuration changes and improved their application caching module. Also identified overheads in maintaining nonclustered indexes on heavily accessed table and redesigned the table structure, indexing structure and physical index data layout and achieved significant performance improvements. This was expected to seamlessly and optimally process queries through Calypso’s trading application. Also discussed on their replication system using 3 ASA and ASE databases and recommended on their nonclustered index structure changes to eliminate the delay in process of SSREMOTE to apply changes (updates) to ASE table from ASA.
• Onsite visit to Confidential Inc. Menlo Park, CA, to take care of their production database server instability during heavy use of dynamic embedded sql from their homegrown C application for online trades. Analyzed Confidential ASE’s implementation of Light Weight Procedure model to process dynamic embedded sql queries using internal diagnostic tools like sybmon, Monitoring system activity using sp sysmon during peak & non-peak hours and gathered important data. Recommended and implemented configuration changes especially in procedure cache management. Recommended application changes to properly allocate and deallocate prepared sql statements to efficiently handle these dynamic embedded sql in ASE using LWP implementation.
• Consulting assignment to Excel telecommunications, Arlington, Dallas, Texas, which involved writing Unix shell scripts (Korn & csh) to gather diagnostics information to troubleshoot a problem with Confidential ’s ASE server’s ability to handle simultaneous stress level connections from Telecom application ARBOR. The script used many diagnostic tools like sp sysmon, sp showplan available with ASE and HP Glance with HP-UX.
• Onsite Visit to Beyond.com, Mountain View, California, to do Performance and Tuning, Recommended query optimization changes, Future configuration recommendation with respect to memory and cache setting, System monitoring and evaluation. I set up optimal configuration of ASE to host their web application which had to be configured to seamlessly process their promotional coupons to sell the software products online.
• Professional services Consultant to Cingular Wireless, Pleasanton, California, to take care of their application testing problems they faced with their reseller application from Ericsson, a Network Element monitor and switching application running on ASE 12.5.0.3. Identified the possible problem with them using the latest features, reproduced problem, identified bug and recommended fix to the bug and requested Engineering to build a ONE-OFF EBF. With this Cingular was successfully able to deploy the Network Element monitoring application used to cover the entire region of Cingular’s wireless coverage.
• Consulting at PeopleSoft, Pleasanton, supplement to SWAT TEAM member and helped in Performance and Tuning of ASE and query optimization with ASE hosting PeopleSoft’s Peopletools application
• Staff Software Support Engineer
• Experience in supporting DBA functions including backup scheduling, disk management, transaction log management, user administration, and activities such as performance Tuning, Query Optimization, Database Consistency Monitoring, and Disaster Recovery and Replication in Confidential environment.
• Resolve and manage Confidential customer’s problems on variety of Operating System and infrastructure platforms in the areas of DSS, OLTP and WEB.
• Helped Engineering in identifying and fixing bugs in the ASE Server.
• Created Instrumented servers for further diagnosis of the problem.
• Provided consults to Technical Support Engineers, other Product Support Engineers and to clients either onsite or over the telephone.
• Help Confidential partners make best use of Confidential features.
• Very low-level database patching using patching tools like sybedit and diagnostic engine.
• Taught brown bag sessions on all types of corruption errors, how to diagnose them and fix them, patch page linkages, physical allocation information and fix database corruption.
• Review and write required product documentation errors.
• Trained new hires, engineers and customers on new products, new features and new versions of products.
• Taught 7 days class on Introduction to Java, Java in Confidential ASE and JDBC.
• Responsibilities included Team lead functionality by
• Discussing and handling customer escalations on technical issues for regional tech support group.
• Initiating, contributing and managing processes, projects and consulting email alias and newsgroups to transfer knowledge to the team.
• Technical support web site development:
• Assisted in the development and maintenance of regional tech support web page consisting of a tool to make Confidential Adaptive Server Errorlog viewable in a browser, a tool to automatically download ftp files into appropriate case directories from psaftp. Confidential .com site where customers normally put the case related files, scripts to display current load on any given queue by day of the hour and by the support engineer and by team, scripts to archive all kinds of statistics for any given queue
• Assisted in the development of web based Repro Portal tool, which facilitates setup of repro environment with any combination of products on any required platform with ease of changing the different version of products to setup repro and evaluate. This tool uses a web client accessing Confidential enterprise application server (EA server). EA server uses Jconnect (JDBC) to access ASE 12.5 containing repository information. ASE does RPC to Confidential Xpserver which accesses and run OS K shell scripts to achieve the repro setup.

Confidential

Senior Technical Support Engineer

Responsibilities:

• Providing professional, courteous, and prompt first and second level technical support for Adaptive Server Enterprises and replication server critical system down and performance tuning cases.
• Query optimization and Performance tuning.
• Creating databases and transaction log Management.
• Extensive usage of K-shell, C- Shell Scripts.
• Installation, Configuring Confidential SQL Servers.
• Upgrading Confidential SQL Servers and perform problem determination.
• Automating backups to run through Shell Scripts and ensuring that these backups are running fine.
• Administrative and Production support of various applications in all environments.
• Defining, standardizing, testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.
• Installation, configuration and administration of Replication Server (Versions 10.x, 11.x, 12.x, 12.5)
• Attended Confidential Classes on ASE administration, internals, performance & tuning and Confidential certified