PROFESSIONAL SUMMARY

Oracle/SQL Server DBA professional with 11 years of extensive experience in managing production/development/test Oracle/SQL Server databases.

Data architect with Business Intelligence BI implementation skills: requirements/process analysis, conceptual and detailed design, relational conceptual, logical and physical modeling and dimensional modeling star/snowflake schema, implementation of cube data warehouse, testing, training, and support. ETL Design, Scheduling, Deployment and data loading using SSIS.

Hands-on DBA experience with production Real Application Clusters RAC including installation, configuration, tuning and maintenance in both Linux and Sun Solaris environments and with installation, configuration and management of Oracle Data Guard Architecture together with Automatic Storage Management ASM and Flashback technologies.

Thorough knowledge of Oracle architecture with proven experience in database administration for Oracle databases Oracle 8i, 9i,10g,11g, 12c in both OLTP and DSS environments including configuration, patching and upgrades, migration release, database monitoring and security management.

Thorough knowledge of MS SQL Server architecture with proven experience in database administration for MS SQL Server databases in OLTP, OLAP and SSIS environments including configuration, patching and upgrades, migration release, backup, recovery, database monitoring and security management in Always-On and Failover Clusters.

In-depth knowledge of Oracle Recovery Manager RMAN for backup and recovery solutions for Oracle databases with storage technology and Media Management Layers.

Proficient in writing SQL queries and developing SQL stored procedures.

Excellent performance tuning skills at SQL Server and Oracle database and at Windows 2008 and Linux/Unix OS level, also strong skills in SQL tuning and debugging, hand-on experience with database design and data modeling.

Technical lead for many IT projects with role in database architect and process development.

Possesses effective interpersonal communication and organizational skills.

TECHNICAL EXPERIENCE

requirements/process analysis, conceptual and detailed design/modeling, implementation of cube data warehouse, testing, training, and support. Oracle Database Server 12c,11g,10g, 9i, 8i, 8. Other RDBMS with general side support: MS SQL Server 2000,2005 and 2008. 2012, 2016. Red Hat Enterprise Linux RHEL 3.x, 4.x, 5.x, SUN Solaris 2.x, 8, 9,10, Windows 2003, 2008, 2012. RAC/Red-Hat Linux, RAC/SUN Solaris, Veritas/SUN Solaris, Data Guard, RAID, Backup and

Storage Technology:

Device, Veritas NetBackup, RAID, SAN storage, ISILON,Tape Library, Grid Storage, Commvault Commcell.

Languages:

Shell Scripting, SQL, PL/SQL, Java

Performance and Monitoring Tools:

OEM Grid Control, Uptime, Spotlight Monitoring tool, Quest Performance Analysis, SQL Profiler

Networking:

TCP/IP, LAN/WAN, Gigabit Ethernet, Switches, Hub, Wireless network,

PROFESSIONAL EXPERIENCE

PremierSDN LLC

Database Architect

11/2023 to Present

Used Oracle APEX (or Oracle Application Express) online low-code application to develop and customize application UI, and grant users access to the application via URL.

Migrated Access database to oracle and SQL Server from on-premises to the cloud Oracle Autonomous database.

Connected Oracle Apex to CGI database system through html interface.

Designed logical design of the database object before and after project.

Participated in creating the Proof Of Concept (POC) and presented to our clients.

Created schemas and database objects and loaded data into the tables.

Established ETL processes and Provides support for the data extracts from the

Manage database users, user roles and privileges.

Created Indexes, Synonyms, Performs database monitoring, tuning and capacity planning.

Configure backup and recovery using Oracle Recovery Manager (RMAN)

Managed tablespaces, datafiles. listener and TNSNAMES files

Managed oracle environment in RedHat Linux, Windows, and AIX in a SAN environment using Oracle SRDF, RMAN and OEM

Installed Oracle database, oracle client, Oracle SQL developer, SQL Server migration assistance and utilized these to create and manage database.

Performed data validation after migration to ascertain data integrity of our client.

Downloaded and applied update patches on oracle and SQL server environments. Reasons

Cognosante LLC (Veteran Affairs project managing healthcare data).

IT Manager/Data Architect

11/2021 to 11/2023

Work with the team to evaluate business needs and priorities, liaise with key business partners and address team needs related to data systems and management.

Participate in project planning; identifying milestones, deliverables, and resource requirements; tracks activities and task execution.

Generate design, development, test plans, detailed functional specifications documents, user interface design, and process flow charts.

Developed data pipelines, APIs SQL, Spark and AWS, Azure or GCP Methods.

Use an analytical, data-driven approach to drive a deep understanding of fast changing business.

Build large-scale batch and real-time data pipelines with data processing frameworks in AWS, Azure or GCP cloud platform.

Manage SQL Server database, schema, and table design in a Data Warehouse environment.

Processed Data Loading of external Tables (ELT) into SQL Server Database using SQL Server Integration Services SSIS.

Data modelling – Design database table relationships.

Optimize database performance by adding indexes and primary keys to database tables.

Migrate on-premises databases to cloud in Azure.

Configured and managed Always-On HA and clustered databases.

Experience in Database modeling using data modeling tools (Erwin).

Create pipelines in Snowflakes to S3 Azure Blob storage.

Experience in design, deploy, and operate high availability, cost-effectiveness, and secure applications on both Azure & AWS platforms.

Used Agile framework (SAFe) Agile methodology such as scrum, Kamban board, sprints for team collaboration on project and tasks.

Extensive experience with delivery using ETL/ELT tools and techniques (i.e., Informatica, DataStage, SSIS.

Expert understanding of data warehouse and master data management approaches, ELT industry standards and best practices.

Experience building Data Vault and/or Star Schema and data cube models.

Experience with BI reporting tools a plus such as Tableau

Possess effective communication skills and the ability to work with technical teams and business teams.

Followed HIPPA security and rules and regulations.

Gwinnett County Government

11/2018 to 11/2021

Senior Systems Administrator –Oracle/SQLServer DBA.

Managed SQL Server and Oracle databases in Oracle RAC and SQL Server Failover cluster environments and Always-On Failover.

Installed MS SQL server 2016 database software

Applied necessary patch

Installed SSMS

Created databases and configured backup processes.

Recovered databases and recompiled orphaned users.

Create tables, views and indexes

Created database Roles and grant roles to specific users.

Installed and configures SSRS and setup ODBC connections.

Migrated databases from server to server and version upgrades.

Utilized monitoring tools e.g. Uptime, Oracle Grid Control, and spotlight to monitor database performance.

Designed and configured database backup and recovery processes

Performed import/export of data using sql server import export tool.

Created crontab backup jobs to run at specific times.

Set up RMan backup of databases

Created dumpfiles for backup and recovery. And scheduled to run at specific times.

Refreshed oracle database using database dumpfiles.

Monitor server space and performance

Monitor database security

Utilize CommVault to backup and restore oracle databases.

Participated in an on-call rotation with other dbas.

City Of Atlanta

June 2010 to Nov, 2018

Sr. SQL Server/Oracle DBA

Worked as DBA on the SQL Server installation, upgrade, administration, and maintenance. integration service repository creation and maintenance and database administration. Supported the billing and invoice projects by designing and creating the logical and physical database structure such as data model, database, tables, indexes, stored procedures, triggers, etc.

Perform day to day Database Maintenance tasks - Database and replication Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.

Manage hierarchical security access control, permissions, for databases and ensure data integrity. Ability to prepare for and participate in security audits and disaster recovery measures.

Migrating data among Oracle, SQL Server and Access databases using SQL Server tools such as ODBC, SSIS, linked Server, export/import and Oracle tool such as SQL Load, data pump, etc.

Backup and restore database for disaster and cloning purposes.

Created and configured an OLTP replication database for disaster recovery purpose.

Provided 7 x 24 Production support for the database and application issues.

Tuning the SQL queries using SQL Profiler, Performance advisor, explain plan and hints.

Setting up and maintaining Server Data Backup policies for Daily, Weekly, Monthly

Responsible for installing, configuring and maintaining Oracle 11g R2, Oracle 12c, SQL server 2005, 2008R2, 2012, 2016 on Windows 2008/2012 Server.

Creating database objects like Tables, Stored Procedures, Views, Triggers, Security policies and functions. Backing up and restoring database.

Oracle DBA Sr.

July 2009 to June 2010

IBM GLOBAL

Created, upgrade, and clone Oracle databases versions 8, 8i, 9i, 10g, 11g, 12c . Creating relational Logical/Physical Data Modeling and dimensional data modeling for databases and data warehouses Setup and implement Backup and Recovery procedures using RMAN.

Installation, upgrade, patching Oracle RDBMS software Physical and Logical Tuning of database structures.

Experience with Data Modeling and/or Application Development Supporting multiple projects/tasks simultaneously.

Front-line DBA supporting for 24x7 systems, first stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels.

Diagnose and resolve difficult database and application scalability and performance problems.

Data model design and implementation. Utilized Toad Data Modeler to design and create relational Conceptual, logical and physical model and dimensional model star/snowflake schema and to create the Business Intelligence reference architecture and implement the enterprise data warehouse.

Created standards and design patterns on data movement, data access, data integration, and other areas in the data warehouse.

LGR TELECOMMUNICATIONS

March 2005 to July 2009

Sr. SQL Server DBA/Solution Architect

Responsible for installing, configuring and maintaining Oracle 11g R2, Oracle 12c, SQL server 2005, 2008R2, 2012, 2016 on Windows 2008/2012 Server.

Creating database objects like Tables, Stored Procedures, Views, Triggers, Security policies and functions. Backing up and restoring database.

Migrating data among Oracle, SQL Server and Access databases using SQL Server tools such as ODBC, SSIS, linked Server, export/import and Oracle tool such as SQL Load, data pump, etc.

Backup and restore database for disaster and cloning purposes.

Created and configured an OLTP replication database for disaster recovery purpose.

Worked with developers to tune the SQL queries using SQL Profiler.

Provided 7 x 24 Production support for the database and application issues.

Tuning the SQL queries using SQL Profiler, Performance advisor, explain plan and hints.

System Administrator for Microsoft Windows 2008/2012 Server and Active directory. Creating, maintaining and supporting Active Directory. Managing Active Directory Group Policy and implement Users' and system security Policies on Windows Server. Managing group and user IDs.

Supporting and maintaining server firewall, Remote Desktop Gateway server/clients Creating and installing self-signed digital certificate, which is able to replaces VPN connection.

Setting up and maintaining Server Data Backup policies for Daily, Weekly, Monthly

Managed OLTP 50 TB database environment .

EDUCATION

Bachelors of Science - Information Technology -University of Phoenix – 2007

Certificate Training

Certification – Oracle OCA/OC

Microsoft SQL Server 2014 Database Administration – Jan 2019

Implementing a Data Warehouse Microsoft SQL Server 2016 – April 2019

Oracle RAC 11R3 Administration – Oracle University, Sandy Springs GA 2012

Oracle Database Securiy – Oracle University, Atlanta Ga - 2012

Database Administrator --- Advance Technology group, Atlanta GA - 2009

PC Service and Support --- Boston University Corporate education – 1997

Contact this candidate