PROFESSIONAL EXPERIENCE:

Confidential

Database Administration Senior Engineer

Responsibilities:

• Recommend and implement technologies for database storage and transfer for DBs such as Oracle, MS SQL Server, and no SQL DBs.
• Advanced performance tuning operation for DBs such as Oracle, MS SQL Server, and no SQL DBs such as MongoDB and DynamoDB.
• Management of large, high volume replication topologies.
• Creation and maintenance of accurate monitoring and alerting systems
• Utilising basic understanding of Python and integrating Python with MATLAB.
• Script any task for automation. Also, using Kusto and MATLAB to provide wide range of functions and toolboxes for algorithm development and implementation. And to supports various mathematical and statistical operations, optimization techniques, and machine learning algorithms.
• Deploy DBs objects on Microsoft Azure cloud services and using Azure for analysing large volumes of data from various sources while integrating the sources into single unified service.
• Implement backup strategies for Azure DBs such as Oracle, MS SQL Server, Sybase, Informix, and no SQL DBs such as MongosDB, Couchbase and Dynamo.
• Solve migration issues encounter from on prem to cloud, single to flexible servers.
• Solve restoration issue from cloud while using unique interface such as Palantir Technology etc.
• Azure DBs performance tuning and general Azure DBs administration of resources and users.
• Solve performance degrade between Single & Flexible Server.

Environment: s: Single and Flexible servers for Azure PostgreSQL Hyperscale, Azure Database for Maria DB, Azure Database for Oracle, Azure for DB2, Azure Database for SQL Server Azure Database for MySQL, Banner ERP, MongoDB, Cosmos DB, Casandra Kusto/MATLAB, MS Azure Portal, DFM, Python/PowerShell and ASC. Kubernetes, Azure Synapse and terraform.

Confidential, Ferndale, WA

Database Administrator

Responsibilities:

• Upgrade of the current database from and finally to 2016 for compliance & concurrent to the CMP requirement.
• Use ETL and Data Pipelining for data transportations, operations and performance monitoring and improvement during the upgrade.
• Used PowerShell, Java Scripts and Python for transformation of data from SQL 2014 database to SQL 2016R2.
• Configuration of SILVERTIME database for migration of KRONOS Workforce Central to Workforce Ready (Cloud Environment) while using Data Modelling in the target cloud environment.
• Design and implementation of Database Backup into 3 - tier strategy. That is, local, cloud and VM backup tiers.
• Extensive experience in the gaming industry enables us to fully integrate Casino & Banner ERP such as Revenue Audit, MICS Compliance Reporting and Cash Management.
• SSIS packages for data transformation and migration tasks.
• SSRS packages for reporting Purposes.

Environment: s: Windows 2000, Banner ERP, Tableau and Microsoft Dynamics 365. KRONOS ERP. SQL Server 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2016

Confidential

Responsibilities:

• Configure Alerts to integrate with Assist to generate tickets.
• Worked to leverage OEM to enforce compliance requirements • Update existing shell scripts and create new maintenance scripts.
• Strong, proven Database Performance Diagnostic skills (at both the SQL and system levels) using TOAD and IDERA.
• Worked with features such as Oracle Real Application Clusters (RAC), ASM, Active Data Guard, Oracle Enterprise Manager (OEM) and Oracle Real Application Testing (RAT) .
• Management approach identified as a standard for other infrastructure offshore operations teams, with increased staff retention rates.
• Configuration and Management of Quest Shareplex and Oracle GoldenGate to implement Realtime database replication between the source and target databases. Goldengate Veridata Data Synchronization and Data comparison across different databases or tables, regardless of the underlying platforms or database vendors.
• Became the “inhouse replication expert” for the 24million SFG DB Split project. Worked with actuary business unit for the Oracle Planning and Budgeting Cloud Services (PBCS).
• Used PL/SQL to move database objects to a new Oracle database, that is, migrate the relevant database objects such as tables, views, sequences, and triggers. Ensure that the PL/SQL code s the correct objects, and that any necessary data transformations or conversions are performed.
• Performance tuning and troubleshooting poorly performing queries, using PerfMon changes, sp Blitz, indexing/statistics strategies, partitioning, archiving, execution plans.
• SSIS 2016, including hardware and software configuration, security, and deployment framework.
• Automated install of SQL Server through PowerShell 4.0 scripts.
• Manage the resource of 4 offshore Operations DBAs.
• Operationalized most routine actions for offshore resources. Created Run Books and Knowledge Transfer (K.T) sessions for those resources.
• AWS Cloud Computing - SQL Server/Oracle DBA support on RDS/EC2
• Microsoft Azure Cloud Computing. Update and migrate from existing SQL Server to Azure.
• Tableau and Microsoft Power BI data warehouse experience.
• Using client representational state transfer API to communicate requests to server. Kanban Software for financial Software.
• Experience with features such as Microsoft SQL Server Always-On, Always Encrypted, and Microsoft Business Intelligence.
• Building and Maintaining Automatic Windows Failover from Active node to the other. Employ, T-SQL as a procedural extension in SQL Server to Setup and configure SQL Server Alerts, Get the max size of tempdb and List SQL server roles for users.
• SSIS Designer to create a simple Microsoft SQL Server Integration Services package via ETL.
• I have also used GitHub for distributed version-control system for tracking changes in source code during software development.
• Strong expertise in using Shareplex for replication while taking advantage of features such as Conflict Resolution, Compare and Repair Scripting.
• Power BI connection with MS SQL Server to build an automated Dashboard.
• High Availability and Disaster Recovery solutions for SQL Server while using:
• Single Site SQL Failover Clustered Instance (FCI)
• Database Mirroring o Transaction Log Shipping
• Peer-To-Peer Transactional Replication.
• Multi-Site Clustering with SAN Replication.
• Multi-Site Clustering with NO SAN Replication and with NO shared storage.

Environment: s: Catalogic, TDP, and TSM for data protection and backup, LiteSpeed and CommVault. Microsoft System Center Operations Manager (SCOM) for monitoring and management of health and performance.

Confidential

Database Administrator

Responsibilities:

• Claims and source systems like FACETS, PIMS.
• Data analysis and data transformation between Claims and source systems like FACETS, PIMS.
• Performance Tuning Proficient in Data Modeling (OLTP and OLAP), Data Normalization via JCL(Job Control Language). Experienced with full DB development via SDLC.
• SQL Optimization with Statistics Refresh, index optimization while using utilities such as IBM Runstat.
• Used utilities IBM DB utilities such as Load and Unload, Reorg for data Extract Transform and Load(ETL).
• Strong experience in IIDR (IBM Infosphere Data Replication).
• Implement transactional capabilities of DB2 for z/OS with very fast processing of OLAP and analytical SQL workload in Netezza using IBM DB2 Analytics Accelerator (IDAA).
• SQL Server database administration - Daily review and management of all production back-ups, ensuring all are functioning in alignment with documented standards and procedures. SQL Server database administration - Coordinates regular recovery of data from backups (on and offsite) to ensure the integrity of the process.
• SQL Server Failover Clusters administration.
• SQL Server database administration - Daily reviews, updates, and reports on space usage in alignment with the capacity plan.
• SQL Server database administration - Daily review of all production database alerts and logs for issues.
• SQL Server security administration - Daily review of user access and security.
• SQL Server database performance tuning - Daily identification of problematic queries and management of their escalation, optimization, and redeployment. This also includes Statistics Refresh.
• SQL Server database operations - Review coordinates and promotes all changes affecting production databases in alignment with change control procedures.
• Writes database documentation, standards, and procedures for data definition, data access, and database management that affect the production databases.

Environment: s: SQL Server on Windows 2008, 2016 and 2018. IBM z/OS. DB2 Utilities Suite for z/OS 11.1.0, QMF Classic Edition 11.1.0, IBM DB2 Administration Tool for z/OS, IBM Maximo and Infosphere Data Replication for DB2 for z/OS

Confidential

Oracle Database Administrator

Responsibilities:

• All production back-ups, ensuring all are functioning in alignment with documented standards and procedures.
• Space usage, providing updates and reports to ensure alignment with the capacity plan.
• Production database alerts and logs to identify issues.
• User access and security.
• Problematic queries - identifying, managing their escalation, optimization, and redeployment.
• Used MySQL Workbench as a visual tools for creating, executing, and optimizing SQL queries.
• Escalation to a Senior Database Administrator of any issues appearing to affectdatabase integrity or security.
• Coordinates regular recovery of data from backups (on and offsite) to ensure the integrity of the process.
• Daily review and management of all production back-ups, ensuring all are functioning in alignment with documented standards and procedures. Coordinates regular recovery of data from backups (on and offsite) to ensure the integrity of the process.
• Daily reviews, updates, and reports on space usage in alignment with the capacity plan.
• To prevent high overhead cost, I have sed use MySQL DISTINCT and UNION operators sparingly for optimization, that is, configuring, tuning, and measuring performance, at several levels..
• Daily review of all production database alerts and logs for issues.
• Daily review of user access and security.
• Daily identification of problematic queries and management of their escalation, optimization, and redeployment.
• Review coordinates and promotes all changes affecting production databases in alignment with change control procedures.
• Writes database documentation, standards, and procedures for data definition, data access, and database management that affect the production databases.
• Coaches and mentor complex technical concepts to development team members with varying degrees of technical experience.
• First point of contact for all production support issues.
• Administration of other middleware infrastructure and tools.
• Designs, develops, and maintains Teradata databases.
• Using Erwin Data Modeler/ER/Studio (Alternative to Alteryx Data Modeller) to convert logical data model to Physical model.

Environment: s: UNIX Oracle 11g, SQL Server, Solaris, TOAD, Harvest, CAST Systems. RAC, RAT System, MySQL, MongoDB, Cosmo, Casandra and Teradata.

Confidential, Edmonton Alberta

Oracle Database Administrator/ Oracle Application Server Administrator

Responsibilities:

• Registration of Birth in the province
• Registration of Death in the province, while using daily ETL to Extract, transform in the middle to correct format; and load vital data from other provinces into Alberta.
• Motor Vehicle Registration - MOVES. There is a daily batch job that populates this database into Business Intelligent BI data warehouse with OBIEE. This produces daily reporting, ad-hoc query and analysis, Online Analytical Processing (OLAP), Online Transactional Processing (OLTP), dashboards, and scorecards for decision makers.
• Registration of Company Incorporation
• Support of the National Routing Systems (NRS) for Higher while using Banner ERP. Banner is an integrated student information system which will eventually include online admissions, financial aid, records, student accounts, advising, housing and disability services.
• Interface with SAP, FI Provides a complete financial accounting solution, including income statements, balance sheets, journals, ledgers, and all areas of financial accounting.
• This system, at high level is called CORES/VISTAS and it comprises of production (VSP), legacy (VSPLEG) and Business Intelligence databases (AGSBIP).

Environment: s: UNIX Oracle 10g, Solaris, oracle data warehouse builder, Winscp, Secure Crt, SAP, ETL, OBIEE, Banner ERP, Oracle GoldenGate database replication Tool and SQL Developer.

Confidential, Burnaby BC

Linux+ System Administrator/Project Lead

Responsibilities:

• Obtain Weekly Change Control Requirements in NSPO environment (The environment consist of five different components/modules - Weblogic Applications, Enabler, OMS, Netcracker and Telus Services).
• Develop the preliminary scope of the new requirements and create project scope statement.
• Defining and documenting data during transformation.
• Also capturing the dataflow through Data Lineage to provide 360 View of Data.
• This may include working with project teams or support teams to define, redefine, or continue maintenance of the metadata.
• Ensuring Data Integrity, and Security.
• Working with Project Manager to ensure Data Retention.
• Employing Information Lifecycle Management to ensure Data Profiling, Issue Resolution and Automation of Data Quality rules.
• Ensure Data Security and Privacy according to HIPPA.
• Hardware & System Configuration - Configure kernel modules, network parameters, storage, cloud and virtualization technologies.
• System Operation & Maintenance -Manage software and services, and explain server roles, job scheduling, and the use and operation of Linux devices.
• Security - Software troubleshooting Understand best practices for permissions and authentication, firewalls, and file management.
• Oracle E-Business Suite Products such as Service Order Management, Logistics, Procurement and Projects.
• Linux Troubleshooting & Diagnostics - Networking Analyze system properties and processes and troubleshoot user, application, and hardware issues.
• Automation & Scripting - Execute basic BASH scripts, version control using Git, and orchestration processes.

Environment: s: LINUX, UNIX Oracle 10g, SQL Server, MS PROJECT, Program Evaluation Review

Confidential, Columbia

Database Developer

Responsibilities:

• Obtaining legacy data from the DB2 mainframe via MVS JCL
• FTP the files into UNIX “sand-box”.
• Disabling all the current constraints that enforce business rules.
• Writing Pearl, UNIX and PL/SQL script to reformat and redefine records.
• Loading the records into the new environment
• Enabling all the constraints and triggers that enforce business rule.

Environment: TOAD, LINUX, Oracle 10g, Oracle 9i Developer, DB2 mainframe, Microsoft Visual Source Safe, SQL Plus, Net Configuration Assistance, Oracle Designer

Confidential, Columbia

Database Administrator

Responsibilities:

• Because the ministry acts as a repository for the colleges, my duty includes collecting daily data from the colleges on medication prescribed.
• Records are managed in the Oracle (Unix OS) & DB2( AIX and IBM/MVS Mainframe).
• Tools used to manage, administer, migrate, and generate reports include SQL Loader, PL/SQL, RXSQL, Data Pump, DB2 Control Center graphical interface and REXX (Restructured Extended Executor). Also used PIPES provides a mechanism for sending data between Virtual Machines.
• Modifying non-standard (rejected) data.
• Populating the database.
• Administering the database to accommodate growth.
• Projecting future database need of database resource.
• Writing Perl, UNIX, and PL/SQL script to reformat and redefine records for college use.
• Writing input report for the CASS system, so that the ministry will pay the practitioners in case of Pharmacists, Physicians and Surgeons.
• Enabling all the constraints and triggers that enforce business rule.

Environment: Oracle 9, Oracle 9i Developer, SQL Plus, Net Configuration Assistance and various applications. Unix/AIX, VM/CMS (Virtual Machine/Conversational Monitor System OS) AND DB2 Control Center. IBM VM Batch Facility JCL and COBOL.