Sqlpro Studio 1 0 335 – Powerful Database Manager Resume

1. Sqlpro Studio 1 0 335 – Powerful Database Manager Resumes
2. Sqlpro Studio 1 0 335 – Powerful Database Manager Resume Examples
3. Sqlpro Studio 1 0 335 – Powerful Database Manager Resume Example
4. Sqlpro Studio 1 0 335 – Powerful Database Manager Resume Objective

SQL Developer March 2016 to Current BANK OF AMERICA － Charlotte, NC. Developed Advanced SQL queries and stored procedures to generate data reports. Dug into database details to ensure appropriate data filters, randomizations, and stratifications are applied based on business requirements. Using database level triggers code for database consistency, integrity and security. Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis. Environment:SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE.

Any Town, NY 99999
(999) 999-9999 (Mobile)
(999) 999-9999
E-mail: email@yahoo.com

BRIAN WILSON

A simple, powerful database manager for macOS, iOS and Windows. Download Toggle Dropdown. No problem, SQLPro Studio supports most cloud based instances. Multiple result sets. Need to see the results for multiple tables at once? You can execute multiple queries and have the results for each displayed at the same time, including. JESSE KENDALL 123 Elm Street. Miami, FL 33183 (305) 555-5555. email protected CERTIFIED ORACLE DATABASE ADMINISTRATOR. Accomplished Oracle-certified DBA with expertise in performance tuning, crisis management, and high availability to increase reliability, maximize productivity, and introduce system efficiencies. Resume an Availability Database (SQL Server); 2 minutes to read +2; In this article. Applies to: SQL Server (all supported versions) You can resume a suspended availability database in Always On availability groups by using SQL Server Management Studio, Transact-SQL.

TECHNICAL SUMMARY

Oracle Database Administrator And Oracle Applications DBA

Over 10 years of experience as production Oracle DBA and Oracle Applications DBA (E-Business Suite) in various industries: manufacturing, construction, software, banking and financial, and retail. Proven ability in administering databases and application systems with complex architectures. Experienced in administering, supporting, installation, upgrade and maintenance of Oracle in UNIX, Linux, and Windows platform. Familiar with full life cycle support and implementation and upgrade of Oracle Applications E-Business Suite. Experienced in UNIX, Linux and Windows basic system administration. Familiar with 9iAS and 10gAS. UNIX shell scripting. Effective organizational, multi-tasking and prioritizing skills. Excellent communication, interpersonal skills, and teamwork. Strong customer focus. Clear, concise and detailed documentation. Self-learner, resourceful, and dependable.

Database:

Car mechanic simulator 2018 mobile. Oracle 11g, 10g, 9i, 8i, 8.0, 7.0

Applications:

Oracle Clinical (OC), Remote Data Capture (RDC), Thesaurus Management System
(TMS), Adverse Event Reporting System (AERS), Application Server 10g Release 2
(AS10gR2), Application Server 9iAS, AS10g Forms and Reports Services,
Oracle Applications 11i, 11.0, 10.7 (E-Business Suite),

Operating Systems:

UNIX, Linux, HP-UX, DOS, VMS, IBM-AIX, Windows 2003, XP, NT, 2000

Hardware, Platform:

Solaris, HP, Linux, IBM, Microsoft PC, VM Ware (ESX, ESXi)

PC Applications:

Microsoft Office Suite (Word, Excel, Power Point, Project)

Languages:

Sqlpro Studio 1 0 335 – Powerful Database Manager Resumes

SQL, PL, SQL, C, HTML, XML, unix shell scripts, perl

Tools, Utilities, Other:

RMAN, Data guard, SQL*Plus, SQL*Loader, SQL*Navigator, J2EE, JAVA Servlets,
Apache, Jserv, TCP, IP, ftp, OEM, OAM, SQL*Net, SYSADMIN, AD tools

PROFESSIONAL EXPERIENCE

Job Title: Senior Consultant (Oracle DBA)
Employer: ABC Inc., ANY TOWN, NY
Dates: 9/2008 to 11/2009

• Created stored procedures and functions which enabled cutting process time down.
• Fine tuning ad-hoc processes of 15 hours down to 15 minutes.
• Scripting SQL code to eliminate manual work.
• Configured and maintained MS SQL 2000/2005 database servers for maximum resources usage.
• Ran SQL 2005 Upgrade Advisor and made preparations.
• Migrated logins, DTS packages, and databases of SQL 2000 to SQL 2005.
• Low-level performance tuning, OS file level defragmentation and database level index defragmentation.
• Fine tuned, stream lined, and automated existing SQL statements.
• Ran Profiler to support application and database developers to improve the database applications.
• Optimized performance at application level processes.
• Secured database server and database objects.
• Monitored and administered services and hardware components of Domain Member Servers.
• Capacity planed on disk storage usages and added internal and external SATA drives.
• Processed average of 200GB Oracle database files monthly.
• Managed average of 500GB flat text file and MS SQL database files monthly.
• Managed 50 GB of the mission critical business logic files.
• Set hot, cold backup, restore routines for business logic and data in different databases.
• Migrated MS ACCESS 2002 databases to SQL 2000/2005 databases.
• Helped team members with C#. NET, ADP, MDB with ADO, and SQL Server Technical Insights.
• Installed and configured Windows 2003 Server Enterprise on RAID 5 SCSI and SATA systems.

Sqlpro Studio 1 0 335 – Powerful Database Manager Resume Examples

Job Title: DBA & Developer (Consultant)
Employer: XYZ Corp., ANY TOWN, NY
Dates: 3/2000 to 8/2008

• Administration of development and production servers running SQL Server 2000, 2005, 2008 and Oracle databases, including creation of indexes, tables, stored procedures, security policies.
• Administration and creation of the Provisioning Training Database back end to train new hires on real time data without affecting production data.
• DBA responsibilities also included routine maintenance such as backups and recoveries, applying patches, upgrades and performance monitoring.
• Ensured SQL Server replication and mirrored databases were operating as planned.
• Scripting of stored procedures, ad hoc queries & triggers.
• Scripting of existing embedded SQL code within applications into stored procedures.
• Responsible for assisting application development team to streamline and optimize queries to adhere to best practices and deliver better performance.
• Contributed to the design of enterprise grade solutions.
• Worked with Data Architects to develop data models.
• Maintained SSRS report servers.
• Developed reports based on well-defined requirements using complex stored procedures and packages to derive the data extracted for analysis.
• Reports included line usage, sales tracking, and cost analysis and frequency analysis reports.
• Crystal Reports 11 and Microsoft Reporting Services were both utilized at the time as a conversion to one reporting system was planned in the future.

Sqlpro Studio 1 0 335 – Powerful Database Manager Resume Example

Job Title: Sr. Oracle And SQL Server DBA
Employer: BCD Inc., ANY TOWN, NY
Dates: 11/1998 to 2/2000

• Responsible for all SQL Server 2000/2005/2008 production databases in large scale, maintenance, upgrade and installation in clustered failover and SAN storage environment, database instance and server level performance, and space usage monitoring.
• Developed and maintenance various TSQL, stored procedures, DTS packages and jobs for People-soft application, which the scalability is over 2000 concurrence users and up 1.5 terabyte database size.
• Detail plan for database replication, backup and restore procedure for disaster recovery and standby database log-shipping, daily database DTS, SSIS developing and implementation.
• Support developer and QE database including database maintenance, application design, functional coding and performance turning.
• Responsible for providing production support of 200+ production Oracle databases and data warehouse servers (15 terabyte) with 99.999% up time requirements running on Solaris with various replication techniques to provide redundancy and load balancing.
• Worked extensively on database administration, storage maintenance, software upgrade, installation, replication monitoring, backup &recovery planning, partition tables, indexes, and performance tuning.
• Documentation and establish standards, guidelines and procedures for all aspects of database optimization and service level agreement.
• Installation & configuration Oracle 10g RAC, Grid, 9i replication, RMAN repository, and UNIX shall script for database monitoring and automation maintenance.
• Application develop support, physical data mapping with application team on vary application including SAP, PeopleSoft CRM, provision process.

EDUCATION

of Southern California
B.S. in Electronics and Communications Engineering

Jrebel 2019 1 4. Texas A&M University, College Station
Operating Systems, UNIX Shell Programming, C Programming

Sqlpro Studio 1 0 335 – Powerful Database Manager Resume Objective

Michigan State University
Oracle 9i SQL and PL, SQL, HTML Web Design and Programming