Review security methods as it applies to the database and recommend improvements.Create pl/sql packages to implement encryption routines and processing of data.Create a testing environment to test security patches and encryption methods.Database maintenancePatching, performance tuning, backup/recovery Oracle 19c, Sql server, and Mongo databaseFollow testing and implementation of new security patches Oracle Database.Review and improve sql from existing applications within… Show more Review security methods as it applies to the database and recommend improvements.Create pl/sql packages to implement encryption routines and processing of data.Create a testing environment to test security patches and encryption methods.Database maintenancePatching, performance tuning, backup/recovery Oracle 19c, Sql server, and Mongo databaseFollow testing and implementation of new security patches Oracle Database.Review and improve sql from existing applications within the database to improve performance.Improve RMAN backups to increase performance and validate backups.Use Oracle data pump, sql loader, and other technologies to move data for data analytics.Implement sql loader to load text files from other agencies for analysis.Oracle Backup and recovery using RMAN, including using datapump.Sql server backup and recovery with testing.Maintain patching Oracle Grid Control.Custom made scripts and enhancements to improve efficiency for applications.Support existing Oracle, Sql Server, and Mongodb databases (24/7 on call schedule)Introduce improvements to database environment to increase performance.Use of ADDM through Oracle Grid (OEM) and customized script.Implement new methods such as partitioning to increase performance in the database.Sql server on Azure. Azure Sql Database, Sql Server Managed Instance.Mongo DB management.Managed and Upgraded Oracle RACSql loader configuration for various data loading projects.Train new dbas and performance reviews. Performance management process committee.Leadership Training with Lucinda Kenning and Trish Holliday with HollidayKenning Show less

Gather requirements for database design projectsCreate ERD and meet with project team for review.Implement high availability/Disaster recovery solutionOracle 10g (RAC) Real Application ClustersOracle 10g ASM (Automatic Storage Management)Implement database security plan for Oracle database systemsOracle Advanced security to secure database files.Implement roles and minimum privileges for users.Apply critical patches and upgrade databases.Upgrade 9i to 10g and… Show more Gather requirements for database design projectsCreate ERD and meet with project team for review.Implement high availability/Disaster recovery solutionOracle 10g (RAC) Real Application ClustersOracle 10g ASM (Automatic Storage Management)Implement database security plan for Oracle database systemsOracle Advanced security to secure database files.Implement roles and minimum privileges for users.Apply critical patches and upgrade databases.Upgrade 9i to 10g and apply critical patches release by OracleSupport existing Oracle databases in an on-call rotationCheck RMAN (recovery manager) backups, export jobs, alert logs.Run performance reports and Check Cluster Ready Services integrity for Real Application ClustersSetup Oracle Grid Control to monitor 10g instances. Show less

Developed and implemented plan for Disaster Recovery, and High availabilityDeveloped and implemented plan to move a SUN/Solaris environment to Intel 64/ Red Hat Linux Enterprise architectureWorked with software and hardware vendors to present new processes that allowed costs to stay within budgetInstalled and configured VERITAS Net backup 6.0., EMC storage, and Oracle Grid Control for centralized database management and proactive performance tuningAssisted application developers… Show more Developed and implemented plan for Disaster Recovery, and High availabilityDeveloped and implemented plan to move a SUN/Solaris environment to Intel 64/ Red Hat Linux Enterprise architectureWorked with software and hardware vendors to present new processes that allowed costs to stay within budgetInstalled and configured VERITAS Net backup 6.0., EMC storage, and Oracle Grid Control for centralized database management and proactive performance tuningAssisted application developers with PL/SQL procedures and operating system level scripts for database jobsMet with business units to determine business casesDeveloped best practices for Database SecurityApplied patches to Sun Solaris, Red Hat Linux operating systems, and Oracle DatabasesWorked with network personnel to improve throughput by running database queries, operating system utilities, and monitoring with network tools Show less

Migrated Oracle 9i version 9.2.0.6 on UNIX Sun Solaris 9 and applied patches as neededDeveloped sql scripts to create custom views, new pl/sql procedures, and generated a data dictionary for Oracle databasesSetup Backup/Recovery Strategy for Oracle databases using RMAN with recovery catalog, export, cold backup, and Data GuardFor SQL Server Databases, used SQL Profiler to analyze table structure and indexes for fragmentationWorked with Server Group to increase performance using… Show more Migrated Oracle 9i version 9.2.0.6 on UNIX Sun Solaris 9 and applied patches as neededDeveloped sql scripts to create custom views, new pl/sql procedures, and generated a data dictionary for Oracle databasesSetup Backup/Recovery Strategy for Oracle databases using RMAN with recovery catalog, export, cold backup, and Data GuardFor SQL Server Databases, used SQL Profiler to analyze table structure and indexes for fragmentationWorked with Server Group to increase performance using iscsi SAN as external storageReviewed software to increase productivity in administrationCreated Oracle database instance for ESRI ArcSDE repositoryWorked with GIS administrator to suggest performance enhancements and data securityDeveloped and implemented enterprise database documentation Show less

Developed new instances based on business requirementsGenerated Physical/Logical ERD using Embarcadero ER Studio and Oracle DesignerCreated scripts and documented database creation during test, development, and production phasesPerformed backups and created users for Oracle and SQL server databasesGenerated Entity Relationship Diagrams for legacy databasesAssisted developers to properly tune sql queriesAssisted client support with connectivity problemsWork with other… Show more Developed new instances based on business requirementsGenerated Physical/Logical ERD using Embarcadero ER Studio and Oracle DesignerCreated scripts and documented database creation during test, development, and production phasesPerformed backups and created users for Oracle and SQL server databasesGenerated Entity Relationship Diagrams for legacy databasesAssisted developers to properly tune sql queriesAssisted client support with connectivity problemsWork with other administrators to implement new and improved features Show less

Designed, analyzed, and modified computer programs to adequately meet needs of users.Reviewed program logic, write, or revise code according to specificationsDeveloped accident and related data and rates in visual basic and pl/sql.Developed charts and reports with Microsoft Access and Excel.Assisted other department personnel to create pl/sql for Oracle database.Researched and provided feedback to management about system design to effectively implement a… Show more Designed, analyzed, and modified computer programs to adequately meet needs of users.Reviewed program logic, write, or revise code according to specificationsDeveloped accident and related data and rates in visual basic and pl/sql.Developed charts and reports with Microsoft Access and Excel.Assisted other department personnel to create pl/sql for Oracle database.Researched and provided feedback to management about system design to effectively implement a solution.Modified existing programs and procedures to access new dataPerformed quality control of data. Show less

Provided computer support for other technicians.