Joe Soria Email & Phone Number

Helena, Mt, Us

San Francisco, California, Us

This fast-paced, micro-services environment leads to my primary responsibilities of initializing new databases, performance tuning, backup and recover and database security. Management of infrastructure within our AWS environment to support our Postgresql 11+ databases utilizing Kubernetes Orchestration.

Billings, Montana, Us

Us

Managed the implementation of Remedy ARS Change Management and Incident Management software. Organized installation of hardware, Oracle databases and configuration of ARS software. Also responsible for end to end customization efforts. Key player in the ongoing effort to correlate data between the company billing (CSG), provisioning (Alopa), incident management (Remedy) and cable modem management systems (Auspice), including development efforts related to the company enterprise network management server and traps receiver (Intermapper). Responsible for availability and tuning of all Oracle 9i and 10g production environments running both basic and advanced replication, as well as, multiple production MySQL databases. Provide support to many different tiers of the organization including the Network Operations Center, Call Center, Marketing, Sales and Engineering departments from a data and business process persective. Responsible for reporting, backup and recovery, development, performance tuning and connectivity to all production databases. Developed database to support a customer element inventory system and developed an ETL tool for ease of data loading. Developed a reporting module with Remedy/Perl/SQL which extrapolates data from many different applications and databases and consolidates the data into a centralized reporting environment.

Us

Sr. Oracle 8i/9i Database AdministratorResponsible for gathering database requirements and performing databasearchitecture. Managed, monitored and maintained over 50 production,development and testing databases. Production databases support the most current implementation of Bridgewater Radius, Nexverse Softswitch, Cisco Tacacs and ICG Raspooling. Developed triggers, stored procedures and numerous Oracle jobs using PL/SQL. Also designed and developed an ETL tool to capture internet connection accounting records in real time for the billing of ISP customers. Current projects include there-engineering of many in-house database solutions, as well as, themanagement of all engineering database & data warehouse projects.

Designed, developed and administered multiple production databaseenvironments for an engineering department and network operationscenter. Implemented Remedy Help Desk and assisted in linking Remedy toour network inventory system as well as with NetCool. Utilized Perl DBIand UNIX for data linking and customized reporting. Also responsible for Remedy customization. Experienced with Remedy forms, Active Links,Filters, Escalations, Menus and Groups. Responsible for disasterrecovery of all corporate databases running on SQL Server and Oracle.Participated in the NOC on call rotation.

EngineeringCurrently developing a corporate wide transaction based databasesolution to serve as the billing module for DSL customers. PrimaryArchitect of a repository for storing information such as networkinventory and network element provisioning. Responsible for configuringa high availability Oracle database solution running on a SUN Solarisserver, developing backup and recovery standards and compiling adatabase data dictionary document to aide in selecting other databasesolutions throughout the corporation. Highly experienced in therequirement gathering, data modeling and database administrationtechniques supporting the full lifecycle of a production databasesolution.

Database Administrator responsible for analyzing new databasetechnologies and strategies. Primary responsibilities included directing development efforts in an Oracle Data Warehousing project. Constructed the company wide backup and recovery solutions for a clustered UNIX systems. Other objectives included the automation of UNIX and database monitoring scripts, with a primary focus user security and high availability. Project manager for year 2000 testing scenarios. Responsibilities also included importing and exporting data, developing user security standards, and providing application support.

Database Administrator for a proprietary OLTP GIS database running onOracle 7.3.4. Primary functions include loading data, data manipulation, reporting and implementing SQL, Perl and C-shell programs into the production environment. Directed the RACS laptop deployment project, a project focused on providing field engineers with laptops configured with the Windows95 operating system and proprietary software required for field communications and off-site data manipulation. Developed the Database Administrators Best Practices Guide, focusing on standards and procedures for transitioning third party data into theproduction environment.

Responsible for the development, availability and integrity of severalproduction and development demographic Data Warehouses sized up to 600Gigabytes. Developed guidelines for database backup and recovery, andactively pursued the enhancement of the company's Data Warehousingmethods. Implemented metadata to enhance query performance. Coordinateda data definition document and metadata document for each databaseinstance. Provided support to project managers on key issues regardingproduction support and Data Warehouse release dates. Key player in theOracle7 Database Administrators Best Practices Guide. Otherresponsibilities included testing company-developed software,standardizing testing scenarios, and analyzing SQL queries.

Responsible for maintaining product-pricing information, databaseadministrator for company Sybase database, and defect tracking databaserunning on Informix. Developed SQL queries and reports for all divisionsof the corporation. Played a key role in the development andimplementation process of the SAP product database running on Oracle.Initial Database administrator for defect-tracking database running onSYBASE. Performed database administration responsibilities for billingdatabase running on INFORMIX. Standardized company software releasedistribution.

Education record

Education record