PROFESSIONAL SUMMARY:

• Healthcare/Financial/ecommerce, and Client Server applications using MS SQL Server 2016, 2014, 2012, 2008 R2, 2005, 2000 Administration.
• Production 24/7 support and maintenance over 16 years of MSSQL DBA, Responsible for SQL Server database designed, installation and setup in standalone, clustered, in physical server and VMware technologies environment, data access permissions and privileges, maintenance setup, storage allocations, Mirroring, performance tuning, Tables, Triggers, Stored Procedures, Power Shell, backup and recovery setup in standalone and clustered environment.
• Configured Database Audit Server for Management reviews.
• Supported over 800 Servers in an environment with 40 applications.
• Configuration of SQL Server 2014 Enterprise.
• Configuration of SQL Server 2016 CTP 3.0.
• Configured and managed SQL Server 2014 Always on Configuration.
• Provide SQL Server technical leadership in project
• Disaster recovery strategies and setup. MSSQL setup in SAN Infrastructure and NetAPP mount point experience
• Perform data loads, database refreshes and general maintenance
• Operating System Installation and support Windows Server 2012, 2008 R2, 2008, 2003, 2000 Standalone and Clustered environment.
• Migrate SQL 2012 R2 into SQL 2016 Availability Group.
• AZURE SQL Server Database Administration.
• AZURE SQL Server Database Migration .
• Performance tuning, speedup slow/blocking 2014
• Troubleshoot SQL blocking and resolve deadlock
• Troubleshoot production SQL Server critical incidents
• Provide SQL Server detail design build documents
• Design and Implement High Availability(HA) Disaster Recovery (DR) strategies, using SQL Replication, Log Shipping, and Database Mirroring
• A self - motivated, team player, database professional with proven experience in the SQL Server environments.
• Strengths include supporting large production database environments as well as data modeling, design and performance tuning.
• Design and develop organizational procedures and reviews processes.
• Successful in decreasing number of user complaints and time to solve them.
• Writes and design departmental procedures and standards.
• Works well independently and as part of a team in a fast paced deadline driven environment.
• Extensive IT experience in collecting/analyzing requirements, system design, and client/server.
• Strong working knowledge of 32 bit/64 bit Windows Servers.
• Configure SQL Mail for alerts and job failures.
• Active Directory Administration in Windows 2003, 2008, 2012.
• Responsible for Database Maintenance using Red Gate and SQL Safe for Backup/Restores.
• Design and Implement high availability OLTP strategies, under RAID-10 for better performances.
• Design, Create and Implement SSIS ETL process, (Extract, transform and load) databases in data warehouse that involves: Extracting data from outside sources, Transforming it to fit operational needs loading it into end target database or data warehouse, from various sources into MSSQL Database, such as Flat files, Excel, Access, Sybase, MySQL and Oracle Database.
• BI Developer, using SSIS, SSAS and SSRS.
• Design and implement Data Warehouse, using SSAS, create and Manage OLAP Cubes, OLAP processing, Dimensions, MDX, Create and manage Security Roles, Develop key performance indicators KPI, implement actions and monitor the cube activities.
• Production 24/7 support and maintenance over 7 years of ORACLE DBA support, Responsible for ORACLE database designed, installation in Oracle 9i, 10g, 11g, and 12c.
• Planning Backup/Restore strategies, planning scheduling backups, logical backups with export/import data pump utilities. Manage users and Roles privileges.
• OS Linux (HP-UX, AIX), Linux and Windows
• RDBMS ORACLE Server 12c, 11g, 10g R2, 8i, 9i,
• Administer Oracle 11g Database on AWS EDS
• Install Oracle 12C Database on AWS EC2
• Temp tablespace alerts, temp tablespace handling, temp tablespace utilization reports.
• Scripting Shell scripting, PL/SQL
• DBA Tools Toad, DB Aretsian, SQL Developer, SQL*PLUS, OEM Grid, Golden gate
• Backup Tools RMAN, SQL-Backtrack, VERITAS Netback up, BCV Sync Split,
• Install Oracle Linux 6 on VirtualBox
• Ticketing Tools iServe( Service now), Remedy, HP Service Desk, Service Request Manager(TSRM),
• Database architecture, high availability and disaster recovery.
• Backup and Recovery RMAN, standby and Dataguard.
• Install and Administer Oracle Data Guard with physical Standby Database
• Install and Administering Oracle ASM, RAC & GRID INFRASTRUCTURE 12c
• Install and building two Virtual Machines
• Install and Administering Oracle 12c GoldenGate in Linux Appliances
• Create an Oracle GoldenGate configuration between two Databases
• Implement Oracle GoldenGate Initial Load, Configuring Change Capture and Change Delivery
• Implementing Encryption in oracle GoldenGate. Implementing Coordinated Replicate, Implementing DDL Replication and Applying Oracle GoldenGate Patch sets
• Install and Patch Weblogic.
• Grant Roles, files and user privileges.
• Determines database structural requirements by analyzing client operations, databases, reviewing objectives with clients, evaluating current systems.
• Develop database solutions by designing ETL process or proposed systems, defining database physical structure and functional capabilities, security, backup, recovery specifications.
• Install and configure database systems, document actions.
• Maintain database performance by identifying and resolving production and application development problems, evaluating, and install new releases.
• Prepares users by conduction .
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Tableau (Dashboards, Data Extracts, Analytics)
• Experience providing dashboard presentations and working with business partners on the best way to display information, visually appealing reports and dashboards including graphics/charts
• BI reporting tools, Power BI, Power Pivot and SSRS
• BI Stacks SSIS, SSAS, SSRS design and implement.

PROFESSIONAL EXPEIRENCE:

Confidential, Mission Hills, CA

Sr. SQL/Oracle DBA Lead

Responsibilities:

• Responsible for day-to-day operations for Production and Development databases.
• Worked on Production data loads and database refreshes.
• Perform data transparency on the Backups and restores.
• Install and configure SQL 2014 Always On.
• Configure the SQL Transactional and Snapshot Replication.
• Maintain the Reporting Server for performances.
• Worked with application team on troubleshooting the data performance issues.
• MSBI developer designing, extract, transform and loading data in the Data Warehouse.
• Design, Create and Implement SSIS ETL process, (Extract, transform and load) databases in data warehouse that involves: Extracting data from outside sources, Transforming it to fit operational needs loading it into end target database or data warehouse, from various sources into MSSQL Database, such as Flat files, and Oracle Database.
• Configure the security strategies in the Data Warehouse.
• Configure the Analysis Services for the Data Warehouse.
• Responsible for applying current patches on the SQL Servers.
• Set up Full and Differential Backups using SQL Native, and Red Gate.
• Design and implement Database security.
• Recommend to the client on hardware and software upgrades
• Did Migrations from SQL 2012 to SQL 2016.
• Support for development, testing databases
• Installation and administration of Oracle 10g and 11g.
• Administer Oracle 11g Database on AWS EDS
• Install Oracle 12C Database on AWS EC2
• Database Upgrades from 11g to 12c
• Performance monitoring, tuning and troubleshooting on Oracle Databases.
• Maintaining database space requirements (Table space, Extents)
• Monitoring resource utilization/Memory utilization in Linux
• Applying RDBMS patches using OPATCH and maintaining Oracle Inventory.
• Monitoring database growth and planning, for future storage requirements.
• User administration, file System management, device management, volume management, spool administration. Backup the Databases using RMAN.
• Managing user privileges and roles.

Confidential, Cerritos, CA

Lead Sr. DBA

Responsibilities:

• Work with the in-house and offshore developers
• Comply with the Healthcare HIPAA compliances
• Responsible for day to day operations for DEV, UAT and Production databases
• Perform numerous of data loads and database refreshes
• Install and configure SQL 2012 Always On
• Install and configure SQL 2014 Always On
• Install and configure SQL 2014 clustering in VMWARE environment.
• Install and configuring MSSQL 2012 Server Clustering in VMWARE environment
• Migrate SQL R2 and 2012
• Migrate SQL
• Design and Implement SQL Transactional and Snapshot Replication
• Scheduled numerous of Jobs using SQL native and SSIS packages
• MSBI developer designing, extract, transform and loading data in the Data Warehouse.
• Design SSRS reports for management usage.
• Deploys numerous of SSIS packages in Integration Services and scheduled the jobs with it
• Managed database performance tuning, maintenance and plan data growth and purge process
• Set up backups for user and system database
• Responsible for applying current patches on the SQL Servers
• Recommend to the client on hardware and software upgrades
• Design and implement Database security.
• Worked with application team on resolving data conflict handler and troubleshooting replication issues.
• Responsible for Database Maintenance using Red Gate and SQL Safe for Backup/Restores.
• SQL Database performance tuning.
• Designed and developed OLAP using MSSQL Server Analysis Services.
• Created Complex Queries, Views, tables, and functions on OLTP environments.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink)

Confidential, Van Nuys, CA

Sr. SQL/Oracle DBA

Responsibilities:

• Responsible for day to day operations for DEV, UAT and Production databases
• Perform numerous of data Replications
• Install and configuring MSSQL 2012 Server Clustering and Standalone in Physical environment
• Migrate SQL 2008 R2 to 2012
• Migrate SQL 2008 R2 to 2012 in SQL Availability Group with 4 SQL Databases of the Replicas.
• Configuring SQL 2012 AlwaysOn Availability Groups.
• Design and Implement SQL Transactional and Snapshot Replication
• Scheduled numerous of Jobs using SSIS packages
• Deploys numerous of SSIS packages in Integration Services and scheduled the jobs with it
• Managed database performance tuning, maintenance and plan data growth and purge process
• Set up Full and Differential Backups using SQL Native, and Red Gate.
• Set up backups for user and system database, schedule data purging/archiving, update statistics
• Responsible for applying current patches on the SQL Servers
• Recommend to the client on hardware and software upgrades
• User Management-Roles/Access Management for users
• Resolve any database performance issue.
• Export and Import of Database using data pump utility
• Work with Change control team for any release in prod environment.
• Monitor databases using OEM Grid control.
• Monitor Data Guard environment.
• Clone of database using RMAN.
• Working on Refreshes of database in Dev and QA environment from Prod backup stored on NetBackup using RMAN.
• Worked on creating scripts for RMAN incremental backup for newly created databases.

Confidential, Westlake, CA

Database Architect/Data Warehouse Engineer

Responsibilities:

• Work with the offshore developers and the business analyst in house
• Comply with the Banking compliances requirements.
• Implement and creating SSRS reports and Report Builder
• Responsible for day to day operations for DEV, UAT and Production databases
• Perform numerous of data loads and database refreshes
• Responsible for the QlikView BI reporting
• Install and configuring MSSQL 2012 Server Clustering in VMWARE environment
• Migrate SQL R2 and 2012
• Design and Implement SQL Transactional and Snapshot Replication
• Design numerous of Flat Files into SQL Server Tables using SSIS
• Design numerous of Excel files into SQL Server Tables using SSIS
• Design numerous of Access Tables into SQL Server Tables using SSIS
• Scheduled numerous of Jobs using SSIS packages
• Deploys numerous of SSIS packages in Integration Services and scheduled the jobs with it
• Managed database performance tuning, maintenance and plan data growth and purge process
• Set up backups for user and system database, schedule data purging/archiving, update statistics
• Responsible for applying current patches on the SQL Servers
• Recommend to the client on hardware and software upgrades
• Design and implement Database security.
• Worked with application team on resolving data conflict handler and troubleshooting replication issues.
• SQL tuning and Database performance tuning.
• Responsible for Database Maintenance using Red Gate and SQL Safe for Backup/Restores.
• Configure logical storage structure
• Design user permissions

Confidential, Santa Monica, CA

Database Engineer

Responsibilities:

• Work closely with the application programmer’s on following the company standards and user requirements in Production Support 24/7.
• Implement and creating SSRS reports
• MSBI developer designing SSIS packages, SSAS and SSRS reports.
• Designed create physical structure, Migrate SQL, making sure all appropriate perimeters are set. All orphan users id’s issues are been resolved and all backup/restores are in place accordingly
• Responsible for day to day operations for DEV, UAT and Production databases
• Responsible of database refreshes from Prod to UAT or DEV for developer’s data manipulations or data massage purposes
• Install and configuring MSSQL 2012 Server Clustering in Physical Server and VMWARE environment
• Install and configuring MSSQL 2008 and 2008 R2 Server Clustering in Physical Server and VMWARE environment
• Install and configuring MSSQL 2008 and 2008 R2 Server stand alone in Physical Server and VMWARE environment
• Install and configuring MSSQL 2005 Server Clustering in Physical Server and VMWARE environment
• Install and configuring MSSQL 2005 Server stand alone in Physical Server and VMWARE environment
• Implement database mirroring in SQL 2005 and 2008
• Perform numerous of data loads and database refreshes
• Design SQL Log Shipping, Mirroring and Replication
• Design numerous of SSRS reports
• Deploys numerous of SSIS packages in Integration Services and scheduled the jobs with it
• Managed database performance tuning, maintenance and plan data growth and purge process
• Set up backups for user and system database, schedule data purging/archiving, update statistics
• Work closely with the developers, programmers, business analyst to provide database standards and the best practices
• Responsible for applying current patches on the SQL Servers
• Recommend to the client on hardware and software upgrades
• Administering EPICOR E905 and E10 Application.
• Support EpicoPilot 905 dashboard, in Test and Production environment.
• Support the Epicor Application System Monitoring on all Task such as EDI processing.
• Troubleshoot all E9 delay activities.
• Troubleshoot EpicorProd905 Web Services for the dashboard performances.

Confidential, Mission Hills, CA

Sr. DBA/Developer

Responsibilities:

• Responsible for database design configuration and installation on SQL physical environment, and administration for the Financial Services.
• Comply with the Financial Institution standards and user requirements
• Designed DB logical model, created physical structure, work closely with the SQL Database application programmers to follow the SQL standards with SQL Server 2008, and 2005
• Migrated SQL 2005 to SQL 2008, making sure all appropriate perimeters are set, all orphan users id’s issues are been resolved, and all data is been backed up and restored in the new environment
• Provided and enforced database development standards to application and Web developers, making sure appropriate permissions and privileges are been assign to users and application group, installed the Internet Information Server
• Responsible for day to day operations for Financial Institution Databases related Issues
• Responsible for Replication and Mirroring related issues
• Design Database Mirroring, Replication, Publisher and Distributor
• Responsible for daily data refreshes
• Responsible for Backup/Restores

Confidential, Pasadena, CA

Sr. DBA Lead

Responsibilities:

• Work closely with the product and program groups to comply with the Health Care industry standards and user requirements
• Designed DB logical model, created physical structure, work closely with the SQL Database application programmers to follow the SQL standards with constraints; triggers, and views in SQL Server 2008, 2005, and 2000
• Migrated SQL 2000 to SQL 2005, making sure all appropriate perimeters are set, all orphan users id’s issues are been resolved, and all data is been backed up and restored in the new environment
• Provided and enforced database development standards to application and Web developers, making sure appropriate permissions and privileges are been assign to users and application group, installed the Internet Information Server
• Responsible for day to day operations for Health Connect Databases related Issues
• Responsible for Replication related issues, Data integrity checks, SQL Profilers etc
• Involved in planning Web Utility Databases Farm Designing and Production Architect ring
• Responsible for applying current patches on Web Utility Database Farm Servers and numerous servers
• Install and configuring MSSQL 2005 Server stand alone
• Install and configuring MSSQL 2005 Server Clustering for Active Passive
• Install and configuring MSSQL 2005 Server Clustering for ACTIVE ACTIVE PASSIVE
• Install and configuring MSSQL 2008 Server stand alone
• Design Database Mirroring, Replication, Publisher and Distributor
• UAT and Production data refresh.
• Design and implement Database security.
• Performance tuning involving memory, disk i/o tuning and SQL tuning.
• Configure Idera compliance for SQL compliance manager to monitor the health on the MSSQL Databases
• Managed database maintenance (backup/restore), plan data growth and purge process
• Installing and configure sqlBack Track Disaster Recovery for MSSQL Databases Backups and Restores
• Install and configure Oracle 9i and 10g on Windows 2008 R2 and Linux environment.
• Grant roles and user permissions.
• Manage user privileges and roles.
• Export and Import of Database using pump utility
• Daily database administration tasks including backup and restore with RMAN, import/export.
• Worked with application team on resolving data issues and troubleshooting various problems.
• Implement database security privileges, and roles, Profiling, Authentication and risk management.
• Provide documentation for database design, analysis, modifications and creating schemas.
• Ticketing Tools (Service now), Remedy, HP Service Desk, Service Request Manager(TSRM).

Confidential, Woodland Hills, CA

SQL DBA/System Administrator

Responsibilities:

• In charge of database administration for IDX projects for it clients Programs in Production support 24/7 environment.
• Work closely with the application programmer’s on following the company standards and user requirements
• Managed database performance tuning, maintenance and plan data growth and purge process
• Configure and install SQL 2000 standard and enterprise versions for the client databases
• Set up backups for user and system database, schedule data purging/archiving, update statistics
• Work closely with the developers to provide database standards and the best practices
• Responsible for day to day operations for the IDX project database related issues
• Responsible for applying current patches on the SQL Servers
• Install and configure Windows 2000/2003 Servers.
• Create File Shared and grant permissions.
• Implement Active Directory.
• Configure DHCP, DNS and IIS Servers.
• Recommend to the client on hardware and software upgrades