PROFESSIONAL SUMMARY:

• Oracle DBA Certified and Over 7+ experience in various Information Technology segments, Offering 7+ years of Professional experience in RDBMS, including Oracle and SQL Server, Proficient in Oracle 9i/10g/11g in various operating systems like Red hat Linux and windows, Database Migrations, Database Capacity Planning, Automated backup Implementation, and Performance Tuning
• Experienced in Linux/Unix shell Scripting
• Created and maintained database documentation and data dictionaries
• Good Knowledge and practical skills in Financial/Capital markets data
• Meets agreed upon goals deadlines with in a team environment
• Excellent knowledge and skills in Data Mining tools and techniques
• Ensured that production servers and databases were available for a 24/7 operation
• Provided business and systems requirements analysis
• Enterprise Linux/Windows platforms and creating databases
• Creating standby databases for disaster recovery and reporting purpose
• Experience with system analysis, design and Data Modeling
• Experience in formulating business requirements and mapping source data to logical and physical database designs
• Experience in managing and maintaining the Data Center and Disaster Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally and Recovering data files, recovering from Block Corruption etc.)
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g R2/12c,SQL Server 2005/2008

Operating System: Red Hat Linux,Windows,Oracle Enterprise Linux

Languages: SQL,PL/SQL,T - SQL, C, C++,PHP, ASP .NET and Java

Oracle Tools and Utilities/SQL Server Utilities and Tools: RMAN, ASM,AUMM, AWR, ADDM, Data Guard, OEM, SQL Loader, Opatch, RAC, Data Pump, Data Guard,TkProf, STATSPACK, EXPLAIN PLAN, SQL TRACE, Flashback Recovery, Oracle Form DeveloperSQL Server Profiler, Database Engine Tuning Advisor(DETA), SSMS, Surface Area Configuration, SSCM, PrefMon, DMVS,Windows Server Performance Monitor,SQL Server Export and Import, Execution Plans

Other Tools and Skills: Data Mining(Statistical Programming in R/Weaka),Data Mining Algorithms(Apriori, Clustering, K-Means, Neural Network and Decision Tree),Data Preprocessing, Data Partition for Test and Train, Data Warehousing, OLTP, OLAP, Confidential Trading System, Basic Network concepts(VLAN, VPN, WAN, LAN and Firewalls),Microsoft Visual Studio, IIS Web Services,Wamp Server,Informatica ETL

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Database Administrator/Analyst

Responsibilities:

• Writing/debugging structured query language with complex joins
• Analyzing structured query for problem resolution and performance optimizing and tuning
• Strongly experienced in writing stored procedure, function and view creation
• Working with the team on the creation of business intelligence applications
• Creating and enforcing database development and operational standards
• Strong attention to detail
• Critical/strategic thinking and problem solving
• Analyzing and documenting user information needs or business problems and determines most effective/efficient programming solution
• Ensuring that applications and processes are well-documented, thoroughly tested, and operate reliably
• Working and resolving database issues independently and with minimum supervision

Confidential

Oracle DBA

Responsibilities:

• Installed, configured and upgraded of Oracle Server Software and related products
• Established and maintained sound backup and recovery policies and procedures as per organization demand using RMAN
• Automated hot backups using a combination of Incrimental,Differential and Full RMAN backups
• Implemented and maintained Oracle 10g/11gR2 Data Guard/standby databases for fail-over purposes and for disaster recovery
• Patching and Upgrading Oracle databases
• Performed hot and cold backups using User Managed and RMAN
• Restoration and Recovery using RMAN (either Complete or Incomplete)
• Performed point in time recovery of database and datafiles using Flashback Technology and RMAN
• Maintained of production database and development database which includes tablespace management, user creation and assigning privileges and roles to users etc
• Proactively monitored database health and taking preventing or corrective action as required
• Performed database tuning and Performance Monitoring
• Used Materialized views, Packages and Dynamic SQL
• Installed, Managed and maintained Oracle RAC for failover and Load Balancing
• Setup and maintains documentation and standards
• Debugging, Troubleshooting Oracle PL/SQL Packages, Stored Procedures and Functions
• Analyzing and Validating database objects
• Maintained archived data on appropriate storage devices
• Maintained and created standby databases using Data Guard and RMAN
• Unix/Linux Shell Scripting to automate DBA tasks
• Designing and Developing Oracle Forms using Oracle Form Developer as per requirements
• Data loading using SQL*LOADER, Logical backups using full Export/Import and DATAPUMP
• Oracle Database Cloning and Refreshing using User Managed Backup and RMAN tool
• Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors
• Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, and ADDM
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL, Data Guard, ASM and OEM
• Monitored system resource availability and responded to system memory and data issues
• Work as part of a team and provide 7X24 supports when required

Environment: Oracle Database 9i/10g/11gR2, Oracle Enterprise Manager, Linux/Windows Operating System, Unix/Linux Shell Scripting, RMAN, ASM, RAC,, Data Guard,SQL Plus, SQL Loader and Oracle SQL Developer

Confidential

Oracle DBA

Responsibilities:

• Installations of Oracle 9i/10g on Oracle Enterprise Linux/Windows platforms and creating databases.
• Table Partitioning, Creating Locally managed Table spaces.
• Experience in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning
• Extensive experience in Automatic Storage Management, RMAN and maintain Standby database.
• Worked with Materialized views.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes
• Applying patches for both Server side and Client side.
• Creation of New Table spaces and relocation of data files for better Disk I/O.
• Supporting and Monitoring data loading, Creating /Analyzing /Scheduling reports, User management, performance tuning using Data warehouse Administrative Control (DAC)
• Monitoring of database objects like rollback segments, temp segments and table spaces.
• Usage of Partitions to improve the query performance and manageability
• Automated the process of analyzing tables.
• Involved in Upgrading of the oracle databases from 9i to 10g
• Installation of Oracle RDBMS server software and version upgrades
• Logical backup using Data pump and Import/export.
• Migrating data using RMAN transportable tablespace
• Created and maintained Materialized Views for replication
• Refreshing/cloning databases using RMAN.
• Created package for Online Redefinition of tables for every day column additions and conversion of tables to partitioned or non-partitioned tables
• Defining and Setting backup and recovery procedures
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Partitioning large objects to improve the performance and manageability.
• Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, and ADDM
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL, Data Guard, ASM and OEM
• Proactive monitoring of databases and applying RDBMS patches, security patches.
• Logical and physical Data Modeling
• Experience in Data Warehousing, Extract Transform and Load (ETL), Oracle Warehouse Builder
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Optimal Space utilization in table space by avoiding fragmentation
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors

Environment: Oracle 9i/10g, Oracle Enterprise Management, SQL Developer, PL/SQL, RMAN, Data pump, SQL*Loader, Import/ Export, Oracle Data Guard and Red Hat.

Confidential

SQL Server Administrator

Responsibilities:

• Installed, Administration and Maintenance Of SQL Server Instances
• Create User and assigned permissions based on the level of database access the user would need
• Created linked servers to SQL servers and other database such as ORACLE, ACCESS etc
• Designed Database Backup and Restoration Strategy
• Writing Stored Procedure using T-SQL to automate certain process and producing reports as per client needs
• Created Database Backups, Monitor those backups to ensure being performed regularly
• From time to time recover the database to a specific point of time, as per requests
• Setup High-Availability as part of Disaster Recovery Strategy for the Databases achieving through Database Mirroring, Log Shipping and Replication
• Troubleshoot SQL Server services outages as they occur, including after hours and weekends
• Monitoring and performance tuning; Physical Server Level, Database Level and Query Tuning and optimization
• Documenting Process, Procedures and Major changes to SQL Server
• Apply service packs
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T-SQL Programming.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects
• To set up SQL Server configuration settings for better server management
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer

Environment: SQL Server 2008/2005, .Net Framework 2.0, Asp.Net2.0,Microsoft Visual Studio, JavaScript,, Windows 2000, Windows 2003 Server, Disk Attached Storage,Wamp Server and PHP,IIS Web Service, Real Time Data Streaming, DNS, LAN, WAN