William Wasley Email & Phone Number

Norfolk, Va, Us

Norfolk, Va, Us

Virginia Beach, Va, Us

Oracle and SQL Server database administration.

Indianapolis, Indiana, Us

• Manage and optimize Oracle databases across development, QA, and production environments • Implement fault-tolerant, high-availability database architectures with cross-region replication • Collaborate with cross-functional teams on database query optimization and best practices implementation • Participate in 24/7 on-call rotation for production system issuesKey Achievements: • Optimized database cloning processes reducing the time by 50% • Decreased daily stats run time by 68% via process improvements• Automated database and OS patching reducing manual work and downtime• Designed and led a comprehensive upgrade process from Oracle 12c to 19c

Newport News, Virginia, Us

• Built SOX compliant IAM strategy for Oracle Cloud Applications • Leveraged Azure AD, CyberArk and SailPoint tools to implement controls and automate security administration • Utilized Oracle Cloud Rest APIs in PowerShell and Java as part of ETL scripting used in batch jobs and environment cloning process • Developed security related data models and reports in Oracle OTBI

Indianapolis, Indiana, Us

• Monitored database health and performance of Oracle 10g, 11g and 12c databases running on RedHat and Oracle Linux • Performed Installation, configuration and troubleshooting of Oracle 10g, 11g and 12c databases running on RedHat and Oracle Linux • Performed database sizing, tablespace management, rollback management, and transaction management in Oracle 11g and 12c • Performed database upgrades from 10g to 11g and from 11g to 12c • Built and maintained 12c Data Guard Physical Standby Databases for production disaster recovery • Installed and maintained Oracle OID 12c and 11g to support LDAP connections • Performed refreshes, replication, backup and recovery using tools such as NetApp SnapManager for Oracle and RMAN • Performed application upgrades of COTS Healthcare apps running on Oracle 11g and 12c databases • Used cron, Tidal Enterprise Scheduler, and OEM to automate tasks, schedule maintenance jobs, and perform some monitoring tasks • Used Data Pump and SQL*Loader to extract and load data • Developed shell scripts, SQL Scripts, PL/SQL Packages and stored procedures to automate administration work • Assisted software developers and data analysts tuning SQL queries, building indices, reviewing execution plans, and other development related work • Performed Oracle security administration tasks, e.g. creating Users, Groups, Roles, Profiles • Applied Oracle quarterly patches (PSU, RU, BU, and JVM updates) • Managed and deployed Oracle Cloud Control 13c • Setup and configured Oracle Database Gateway for SQL Server • Developed end user reports using SQL Server Reporting Studio • Set up inter-database communication using Link Servers and Database Links

Hanover, Md, Us

• Monitored database health and performed troubleshooting of Oracle 11g databases and SQL Server 2008 and later • Maintained security Access Control Matrices for COTS ECM software • Set up Oracle Client, ODBC connections for applications • Configured MS Access as front-end for Oracle 11g • Monitoring and troubleshooting jobs running in Tidal Enterprise Scheduler • Assisted customers troubleshooting MS Access issues and developing reports • Performed Oracle security administration granting and revoking roles from associates

Zhenjiang, Jiangsu, Cn

Zhenjiang, Jiangsu, Cn

Master Of Science (Msc), Information Technology

Education record