SUMMARY

• Has 15+ years of rich and diverse experience in different databases, analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments and that includes 9 years in USA.
• Extensive experience in installation, configuration and administration of SQL Server 7/ 2000/ 2005/2008/2012 .
• More than 9 years of experience as Sr. SQL Database Administrator on Windows 2000/2003/2008/2012.
• Extensive experience in installing, configuration and administration of MS clustering.
• Experienced in T - SQL Programming and performance tuning, optimization
• Extensively involved in 24/7 Production support of the databases and round-the-clock database operations
• SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases
• Supported over 200 SQL 2000/ 2005/2008/2012 servers and 500+ databases in clustering environment (A/A, A/P) and databases 500+ Gig in size
• Import and export data (Dev to QA, QA to Prod)
• Technical Lead in charge of migrating over 180 databases from SQL Server 7.0 to SQL Server 2000 and SQL 2000 to SQL 2005
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/2008/2005/2000/7.0
• Implemented a recovery plan to a point in time failure
• Responsible for data security and Integrity with HIPAA requirements
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, database mail
• A hands-on SQL Server Database Administrator (DBA) and Web Administrator with a proven track record of team leadership and technical skills
• Responsible for establishing best practices, standards
• Responsible for establishing and enforcing security mechanism
• Very good experience in Installation, configuration and maintenance of Oracle/SQL Server.
• Worked with large Databases sizes ( 200gb+) in SQL server Environment
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Experience in Replication - Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Extensive experience with Oracle 9i Database, Replication, performance tuning, data warehousing, Materialized Views, backup and recovery, RMAN etc.
• Expertise in Oracle version from 7.x - 10g and MySQL (4.x - 5.1)
• Used AGILE methodology in Software Development process.
• Performed & Developed a best practices related to Security and Privacy
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Experience in SharePoint 2010 has an administrator
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Had sound knowledge & Experience in SSIS, has knowledge & hands on experience in SSAS, SSRS, SQL Server Clustering and Log Shipping
• Had a methodology and Experience in identify and debugging reports.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
• I have responsibilities in designing document database of architecture. I build data scheme, tables, and procedures. I am a hard worker with compatible attitude.

TECHNICAL SKILLS

Operating Systems: UNIX, Sun Solaris 5.8, Linux, windows 2000/2003/2008/2012/ NT/XP/Ubuntu

Databases: Oracle 7/8/8i/9i/10g, SQL Server 2005/2008/2012, MySQL, DB2, Sybase, PostgreSQL, NoSQL,MS Access 2000

Languages: SQL, advanced PL/SQL, Java, XML, HTML, JDBC, Swing, Java Beans, Applets, JavaScript, JSP, Java-Servlets, ColdFusion4.5

DBA Tools: OEM, User-managed and RMAN Backup and Recovery, Toad DBA Suite, Import/Export utility, SQL*Loader, Oracle RAC, SQL Query Analyzer

SQL Tuning: TKPROF, SQL Trace, STATSPACK, OEM

Case Tools: Designer 2000 v 1.3.2, Erwin Data Modeler 3.1/4.1.4

Reporting Tools: Business Objects XI, SSRS, Crystal Reports, Reports 2.5, 3

ETL Tools: SSIS/SSRS/SSAS, Informatica 7.1/6.2, Ascential Data Stage V 7.5 / 7.1/7.0 / 6.0, SAP-BW 3.1

Other Tools: GIS, Oracle Developer 2K Forms and Reports, Oracle Graphics, Oracle Discoverer, MS Project 2000, SOX, MS Visio 2003, SQL PLUS, PL/SQL Knowledge Expert, TOAD, SQL Navigator, IQ Objects, T-SQL

Hardware: IBM e-Server, HP ProLiant ML 110, Dell 6650, Compaq Proliant ML 330/ DL380

PROFESSIONAL EXPERIENCE

Confidential, Iowa, Panora

Database Administrator/Data Architect

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping. Responsible routine DBA jobs like Backups and Restores.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS). Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008/2012 .
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL. Used Policy Based Administration feature (SQL Server 2008).
• Worked With 'upsert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked on ESRI files, like import and manipulate geodata for marketing analysis
• Prepared Documentation for the Disaster Recovery plan
• Worked on GIS (Geographic Information System ) to provide map, model, query and analyze large quantities of data within a single DB
• Developed plenty of reports using SSRS and Crystal reports.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Used Extensively FileMaker Pro to integrate a database engine with Microsoft Dynamics CRM 2013, also created custom applications based on organization requirement.
• Did Integration with active directory so that you can determine what rights a user has based on their Active Directory credentials used to login to FileMaker.
• Responsible for merging two different version of MySQL database.
• Did data migration from MySQL to PostgreSQL.

Environment: MS SQL Server 2005/2008/2012, T-SQL, SSIS, SSRS, AGILE, Crystal Reports, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008/2012 Server, PostgreSQL, SharePoint 2010, MySQL (4.x, 5.1), SQL Yog, Windows Terminal Services Client, VPN, Microsoft Dynamics CRM 2013, CozyRoc

Confidential, Chicago, IL

Database Administrator / Data Architect

Responsibilities:

• Designed, implemented and documented oracle Data Guard physical and logical standby Database disaster recovery solution.
• Maintain high availability of databases for 24/7 global operation using Oracle RAC
• Databases on Linux operating system. Involved in Implementation and configuration of OEM, Oracle Management Server for Maintenance and monitoring.
• Performing Partial, Complete and Metadata Exports & Imports.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Used GIS system for capturing, storing, checking and displaying data related to positions on Earth’s Surface.
• Tuned SQL queries using TKPROF and EXPLAIN Plan
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
• Prepared the weekly and monthly database health report for Confidential oracle 9i database.
• Actively involved in monitoring the lock processes, releasing locks in case of resource Blockage and gathering statistics.
• Involved in understanding the scope of the application, present schema, data model and defining relationship within and between groups of data.
• Involved in developing the process for extracting, cleansing, transforming and loading the data into a staging area.
• Unit tested various scenarios to ensure that the job design and developments within the jobs meet the requirements.
• Taken good initiative in participating the requirement meeting with the Business and System Analysts and gathering information with an ETL and Business Perspective.
• Worked in par with the documentation procedures and ETL Standards within the company so that the jobs designed and developed are in pace with the future enhancements.
• Writing PL/SQL Procedures, functions and Data base triggers, done the DB2 partitioning (DPF). Used Quest TOAD to tune query performance. Did data migration from Oracle to DB2
• Involved in Data Migration from Legacy application to Product application by using SQL * Loader. Responsible for Creation of new oracle user, and do the import and export of the oracle Database dump.

Environment: Dell 6650, Red Hat Linux 2.0/ 3.0, Oracle 8.1.7.4/ 9.2.0.4/9.2.05/10 gMS SQL Server 2005/2008, DB2, Windows XP/2000, DB2, SQL * plus, Shell scripts, OEM, PL/SQLVi- editor, ER Win Data Modeler, Ascential Data Stage 7.5, Business Objects XI, Oracle 10 gAqua Data Studio 4.7.2, PVCS Tracker 6.0.