Sql Server Data
Resume:
Abrar
***************@*****.***
PROFESSIONAL SUMMARY
•8 years of experience as Oracle and SQL DBA on 10g and 11g R2 database servers with high availability.
•ASM, Data Guard and RAC combined with large database/dataset and Oracle database security.
•Experience in implementing Exadata on multiple sites.
•Work with databases ranging from a few GB to up to 3 TB.
•Build RAC Clusters from scratch.
•Fresh Oracle 10g, 11g R2 and 12c database server installs.
•Strong Linux skills.
•Grid Control, DBConsole and scripts for monitoring database and database servers.
•RMAN and user managed backups for backups/restores and RMAN Duplicate database to clone.
•Export import / data pump, DBLinks for data movement.
•Write Shell and SQL Scripts.
•Set up cronjob.
•Create and manage role-based security to restrict or permit users according to database usage.
•Oracle Real Application Cluster and Flashback technology in Oracle 10g.
•Oracle Data Pump restoring and managing databases across multiple environments.
•Installation, upgrade, configuration, administration and maintenance of very large Oracle databases on most flavors of Unix namely Sun Solaris, AIX, HP-UX, Linux and also on Windows 2000/NT/XP servers.
•Database migrations and database upgrades.
•Work with Storage Admins for carving out partitions for datafile systems.
•SAN, NAS for ASM disks.
•Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
•Physical and logical design of database.
•Monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
•Database Security Administration using roles/grants and Fine Grain Access Control.
•Created Data Guard for RAC and standby servers.
•Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
•First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
•Provide and implement performance tuning recommendations of all components in Exadata database machine.
•Advice, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
•Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
•Develop and record certified proces Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions. ses/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
•Solid skills to configure Exadata to meet company internal security requirement.
•24*7*365 DBA support for databases with a large number of users located all over the world.
•Planning, testing, performing and monitoring database backup and recovery, RMAN.
•Materialize Views.
•PL/SQL, database triggers, functions and procedures
•OEM 12c (Oracle Enterprise Manager), DB Artesian and TOAD.
•UNIX Shell scripts to automate business process and daily backup.
•Oracle GoldenGate
•Worked on instance tuning as per the best practices.
•Identified root cause of performance issue using ASH, AWR, ADDM, SQL Advisor, tkprof, execution plan etc.
•Hardworking, result oriented, enthusiastic, good interpersonal and communication skills.
TECHNICAL SKILLS
Operating Systems
RHEL, HP-UX, Windows, Sun Solaris
RDBMS
Oracle 10g R2, 11g R1/R2
High Availability
RAC, Data Guard, Exadata
Languages
SQL, PL/SQL, Java, C, PERL, UNIX Shell, T-SQL
Tools
RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc
Tuning
TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, DBMS_Stats
PROFESSIONAL EXPERIENCE
NM (Northwestern Memorial Hospital) Oracle and SQL DBA Chicago IL
Jan 2014 – Current
Responsibilities:
• Supporting Oracle Customers running various versions of Oracle database (9i, 10g, 11g and 12c.)
• Build 10g and 11g, 12c RAC
• Set up Data Guard
• Worked on various performances related issues.
• Worked with Storage team for ASM and other file system needs.
• Set up uni-directional Golden Gate for replication.
• Setup the materialize views for replication.
• Provided assistance to Customers In Solving ORA- errors
• Provided assistance to Memory Corruption and Dictionary Corruption Errors
• Provided consultative services to implement the Memory configuration for Database Instance and ASM instances.
• Provided assistance to Implement Huge pages /Large Pages in Unix platforms
• Assistance to High memory utilization issues in Unix and Windows Platforms
• Worked on many data refreshing tickets using Data Pump and RMAN Duplicated database.
• Worked with Oracle Development and Oracle Bug Diagnostics Escalation Team for solving the bugs hit by the customer
• Provided assistance to numerous customers in production Database Hung and non-responsive issues
• Has good understanding of analyzing the hang analyze and system state dumps
• Supported application and professional services to manage their data ranging from GB to TB in oracle database, solving of space problem, data loading problem.
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe.
• Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one off patches.
• Setup the RMAN Backups for all the Production databases satisfying RTO and RPO. Leading in performing periodic DR Drill and testing RMAN backups with various scenarios..
• Evaluated Oracle Database Monitoring and PL/SQL tools.
• Helped on Demand engineers in the dry run for disaster recovery test for On Demand Customer instances.
• Investigate, diagnose, and quickly resolve issues in production and testing environments. Work closely with the customers to quickly resolve production problems.
• Proactive database monitoring using 12c cloud control / 11g Grid Control
• Install Oracle supplied tools to assist in database and SQL Tuning like SQLT.
• Models compliance with company policies and procedures and supports company mission, values, and standards of ethics and integrity
• Provides and supports the implementation of business solutions
• Upgrade/Migration databases from Oracle 9i to Oracle 10g
• Worked on database migration from non-ASM to ASM.
• Setting up and testing the backup and recovery strategies.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Applied various recovery scenarios for complete and incomplete recovery in case of failure
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Installed SQL Server 2008r2 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version 2005 to 2008r2.
• Installed Microsoft Service Packs/Patches/Hotfixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server […]
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
• Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
• Created Reports using SSRS […]
• Utilized DMV's, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
• Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.
Environment: Windows 2003, MS SQL Server […] T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.
Law Bulletin, Oracle and SQL DBA Chicago IL Jan 2013 – Jan 2014
Responsibilities:
•New installations of Oracle RAC, ASM, OEM on 10g, 11gR2 under SLES 11 (SUSE Linux Enterprise Server),Windows, RH Linux, Upgraded and patched existing Oracle homes.
•Plan for new Servers/RAC Databases to host databases that are as big as 3 Terabytes in size.
•Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
•Used exp/imp, data pump and dblinks to move the data
•Worked on standard and enterprise edition of the Oracle RDBMS.
•Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
•Worked on schema Reorganizations for better space management
•Performed Database Refreshes and Database Copies for Development, Test and Production databases
•Installed, Migrated, configured and tested Oracle 9i databases in various environments
•Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
•Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
•Data modeling / Logical database design and implementation (including index design) Migration of system and applications from Oracle 9i to 10g.
•Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
•Create and maintain multiple databases.
•Create multiple 11g databases on RHEL5 in development.
•Schedule backup in 11g using db console.
•Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.
•Involved in SQL programming language by using Pro*C.
•Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
•Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
•Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
•Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
•Set up Physical Standby Data Guard environment for Prod & non-prod databases.
•Setting up of Oracle and Application user accounts and passwords, monitoring application security
•Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
•Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
•Automating the backup processes using shell scripts.
•Build clusters and added nodes.
•Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
•Export and Import of User, Tables and Database using exp/imp and Data Pump.
Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 9iAS; Sun Solaris Unix, Linux
Windows XP, Oracle Forms 10g, Oracle Streams Oracle Reports 10g, Oracle Developer
Exelon, Chicago, IL Feb 2008 – Dec 2012 Oracle and SQL DBA
Responsibilities:
•Used specific relational database management system structure and technology to create and maintain physical databases. Worked with Oracle 9i and 10G databases.
•Interfaced with clients on a regular (daily) basis.
•Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
•Installed and configured database management system software.
•Developed and implemented backup and recovery strategies.
•Implemented capacity planning for databases.
•Served in an administrative role regarding database privileges, security, and migration.
•Developed policies and procedures for system operations to better serve clients.
•Presented database management solutions to internal clients
•Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
•Responsible for quarterly patching and bug fixes.
•Installing, Monitoring, Upgrading Oracle 9i/10g/11g.
•Created Physical standby Data Guard.
•Configured Data Broker Configuration for Data Guard database.
•Practiced switched over and failover for Disaster Recovery.
•Database Backup, Database Restore and Database Recovery using various tools.
•Database Reorganizations for better space management.
•Performed Database Refreshes and Database Copies for Development, Test and Production
•Supported multiple accounts on versions 9i to 11g
•Installation of Oracle 11g, 10g, 9i under Windows, RH Linux, Sun Solaris and Upgrading to new versions and applying patches as required.
•Install, tune and configure complex clustered database environments. Creating Database, Tablespaces, Rollback Segments etc.
•Create and maintain users, roles and privileges.
•Installed and configured Oracle Grid control.
•Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
•Performed Online/Offline database backups.
•Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
•Involved in DB Security, Audit and Risk Management of DB systems.
•Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.
•Involved in monitoring the lock and latches processes, releasing locks in case of resource blockage and gathering statistics.
Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i,9i, 10g, 11g; RHEL, AIX, Windows NT/2000,
HP UX,TOAD, Grid Control, GoldenGate, OEM, SQL Developer
EDUCATION
Bachelors in Information Technology ( 2008 ).
Contact this candidate