Sql Server Engineer

Neelam Saxena

San Diego, California : 858-***-****; : acp6gg@r.postjobfree.com

SKILL SETS

Oracle 10g, 11g, 12c

Oracle 11g RAC

Golden Gate

Oracle 12c multitenant DB

ODI

MS SQL Server 2005/2008/12

T-SQL, SSIS, SSRS, SSMS, DBCC

Database Architect

Data Warehousing

ASM

RMAN

Data Pump, EXP/IMP

SQL, PL/SQL, SQLPLUS

Performance Tuning

SQL Optimization

shell scripting

OEM Grid Control

Enterprise Manager

C#.net, VB.net, VB.6

Javascript, html, oops concepts

Windows XP, Windows 2000, Windows 2008 and Linux

Summary

Above 6+ years of experience DB administration, SQL development, Installation, Patching, Upgrading, Migration, Backup & Recovery, Performance Tuning and Capacity Planning in and Oracle 10g/11g/12c and MS SQL Server 2008 databases on Linux as well as Windows environment.

Professional Experience:

Client – Financial Coach 4U, San Diego, CA (March, 2015 to till date)

IT Intern

Responsibilities

Major responsibilities providing client/server based technical support, database creation in MS SQL Server 2008 Database, maintenance, enhance performance & technical troubleshooting for current database, system analysis, database designing, creating SQL statements, installation software and customization.

Worked in an environment with Very Large OLTP & OLAP databases on various flavors of LINUX operating systems which include both clustered (RAC) and standalone databases using various versions of oracle rdbms.

Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.

Very good experience of working in SQL Server Tuning using Indexing, Partitioning, file size control, data integrity & placing resource limits.

Extensive use of SQL Server tools like Profiler, SSMS, SSRS, SSCM, and SSIS. Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Using Report Builder to create customized Report in SSRS.

Working on SQL Tuning using query optimizer.

Provided on-call support regarding production-related database problems.

Involved in extensive usage of Erwin 4.0 & MS Visio for Data Modeling for both logical & physical design of the database including creation of E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams.

Key Accomplishments: Provided database support and solutions consistently exceeded customer expectations, with the focus on value add.

Client- Tomtom Inc. (Feb, 2011 to Nov, 2014)

Senior Database Administrator

Responsibilities

Lead an internal team of 10 members and provide technical production support to a big unit of 230 members and also responsible for Global SPOC and president of Global technical team. Responsible for Oracle database consistency maintenance.

Involved from the Project initiation phase to the Stabilization phase.

Consistently improved the SLA’s ( Response time, resolution time and proper resolution)

I performed navigation database maintenance, database consistency maintenance, database backup and recovery. Taking L0, L1 & L2 backup. Have performed hot & cold backup. I had been doing production database release for three years.

Strong working experience of performing backup, restore and recovery. Used database shrink operations to manage the file size (Auto_Shrink/manual modes), DBCC commands to check the database integrity. I have worked on Database mirroring and Replication.

Ability to write and troubleshoot T-SQL code and write stored procedures, functions, triggers and worked putting constraints on tables.

Production technical troubleshooting, software installation and support in Oracle 10g & 11g.

Experience in working SQL development. Experienced doing ETL using SSIS from various data sources and extensively used SSAS for analysis & SSRS report services.

Troubleshooting for VM wares and their maintenance and generating health statistics of those.

Perform SQL performance tuning for running production databases, troubleshooting related to Oracle databases in LINUX environment using putty tool.

worked with Oracle GoldenGate tool for real time data integration and replication for 2 or more data. I was involved in installing and configuring Oracle software, VM ware cloning and installation. Worked on tickets assigned by JIRA.

Administered more than 128 OLTP & OLAP Oracle databases bigger than 6 TB. The environments include Real Application Clusters and the Data Guard.

I was doing software & application troubleshooting, analyzing application and software bugs and fixing them.

Experience Oracle Golden Gate components Extract, Trail Files, Obey Files, Replicate, Manager Process, Parameter Files, and Performance Parameters.

Extensively used RMAN with catalog and NO catalog for database backup (cold, hot, full, and incremental) & recovery (database point-in-time, tablespaces, datafile).

Exposure to various database Restore and Recovery scenarios and RMAN PITR, TSPITR, Transportable tablespaces as well as Export/Import Datapump.

After gaining good experience and exposure I also administer my team and share my knowledge with my team. I was involved in attending management meeting for deadlines and other issue discussion. Also I performed many root cause analysis.

Upgraded the database from 9i to 10g & 10g to 11g.

Develop database role security solution for financial, employee and student data.

Support data replication with Oracle Golden Gate and ODI (Oracle Database Integrator).

Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.

Worked on performance and capacity assessment and tuning of large databases. Good experience in SQL Query Tuning and key Oracle performance related features such as Execution plans, Hints, Indexes and table Partitions.

Working on the Technical RCA’s (Root Cause Analysis) for production databases.

Provided on-call support regarding production-related database problems.

Experienced in EM Grid Control. Extensively used for query execution plan, ASH, ASM (Automatic Storage Management) and AWR.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. Size control & capacity planning for the datafiles in Oracle 10g & 11g.

Six Sigma RCA techniques

Summary

Above 6+ years of experience DB administration, SQL development, Installation, Patching, Upgrading, Migration, Backup & Recovery, Performance Tuning and Capacity Planning in and Oracle 10g/11g/12c and MS SQL Server 2008 databases on Linux as well as Windows environment.

Professional Experience:

Client – Financial Coach 4U, San Diego, CA (March, 2015 to till date)

IT Intern

Responsibilities

Major responsibilities providing client/server based technical support, database creation in MS SQL Server 2008 Database, maintenance, enhance performance & technical troubleshooting for current database, system analysis, database designing, creating SQL statements, installation software and customization.

Worked in an environment with Very Large OLTP & OLAP databases on various flavors of LINUX operating systems which include both clustered (RAC) and standalone databases using various versions of oracle rdbms.

Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.

Very good experience of working in SQL Server Tuning using Indexing, Partitioning, file size control, data integrity & placing resource limits.

Extensive use of SQL Server tools like Profiler, SSMS, SSRS, SSCM, and SSIS. Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Using Report Builder to create customized Report in SSRS.

Working on SQL Tuning using query optimizer.

Provided on-call support regarding production-related database problems.

Involved in extensive usage of Erwin 4.0 & MS Visio for Data Modeling for both logical & physical design of the database including creation of E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams.

Key Accomplishments: Provided database support and solutions consistently exceeded customer expectations, with the focus on value add.

Client- Express Weather (EASPL), Pune (Nov 2010 to Feb 2011)

Database Engineer

Responsibilities

Worked on the Database Normalization for weather data.

Worked on Oracle database 9i, 10g, 11g & 12c installation, patching and technical troubleshooting. Size control & capacity planning for the datafiles in Oracle 10g & 11g.

I have worked in migrating database from MS SQL server 2005 to 2008.

Involved in designing “Data Protector” backup strategy for the oracle database.

Worked with ITIL processes (Incidents, Change, Patch and Problem Managements) & SLA.

Tune databases and SQLs using tools like EXPLAIN PLAN, TK-Prof.

Strong experience in RMAN backup and recovery monitoring and maintenance

Strong experience in performing, monitoring the logical backups using EXPDP and IMPDP.

Strong experience in managing instances, tablespaces and user accounts.

Strong experience in Installation and configuration of oracle databases/MS SQL Server 2008/Visual Studio/ArcGIS.

Key Accomplishments: Providing the technical RCA and applying the solution across the databases, technical troubleshooting & analysis.

Client - TechniGraphics India Ltd, Pune (Nov 2009 to Aug 2010)

Database Engineer

Responsibilities

Worked on networking project to develop an software application using C#.net & VB.net and Oracle database.

Did data clone, Install, Upgrade, Configure and maintain Oracle databases Windows platforms.

Perform all database related activities to ensure maximum availability of the databases.

Configured the Oracle Enterprise Manager (OEM) for databases.

Implemented Capacity Planning for the oracle databases.

Created customized tools in ArcGIS desktop using VB.net to convert data in different file formats.

Administering & mentoring software development team, software troubleshooting support.

Manage users, maintain systems security, control and monitor database access

Monitor alert log and trace files & Manage disk space and archive location

Migrate DB between software versions, platforms, DB products.

Graffix InfoTech and Lavasa, Pune India (Jan 2008- Oct 2009)

Engineer

Responsibilities

Web based information system (Pune information system) using ASP.net, HTML, ASPMap & MS Access database. Created desktop based solution using Arc SDE & Arc Engine 9.2 for different projects. Worked in ArcGIS desktop to create models and provided customized mapping solutions for various projects.

Developed desktop based solution using ArcGIS desktop 9.2 & ArcObjects + VBA for "Solid waste management"

Tax Assessment web based application using ASP.net, MSSQL, MS access database.

Installed Oracle 9i and Oracle 10g Redhat Linux 7.3

taking the backups on to tape, monitoring the databases as well as operating system.

Database creation, creating users and user privileges, Creation of roles and assigning to individual users.

Managing Disk storage.

Taking the Physical and logical backups.

Install, configure, upgrade software: server, tools, applications.

Design and implement backup methods and disaster recovery strategies.

SQL and PL/SQL: scripts, triggers, procedures, packages.

Monitor DB growth and provide DB capacity planning for apps expansion

Contact this candidate