Sql Server Manager

Resume of Art Brooks

480-***-****

acxzwb@r.postjobfree.com

SUMMARY

Software engineer tasked with all aspects of systems engineering & development including Database administration, database modeling, database development, .Net developer, visual studio developer and PowerShell developer. I am proficient in SQL, TSQL and VB. I am versed in HTML, Java and C.

Work Experience:

Aetna 09/16 – 01/17

Wells Fargo 2/16 – 8/16

GEO 7/15 – 2/16

Waste Management 01/14 – 6/14

Transperfect Remote Enterpreting 11/12 – 11/14

Arizona Dept Game & Fish 12/08 – 11/12

Customer Funding.Com 9/06 – 12/08

IT Manager Heritage Mint LTD 10/05 – 8/06

Goodrich Oracle DBA 10/03- 10/05

Next Generation Systems 01/01 – 10/03

Oracle Developer Honeywell (Contract) 11/00 – 5/01

Programmer Analyst Apollo Group 7/99 – 9/00

Oracle Contractor (Dial Corp) 4/99 – 7/99

Senior Consultant, Oracle Corporation South West Region 10/98 – 4/99

Project Leader, Arizona Department of Health Services 10/97 – 10/98

Programmer Analyst III, Arizona Department of Health Services 10/95 – 10/97

Programmer Analyst II, Arizona Department of Transportation 10/94 – 10/95

SKILLS HIGHLIGHT:

SQL Server Dba, Oracle DBA, Project Manager, Project Leader, Systems Analysis, Programmer

Operating Systems: UNIX, Windows (All versions, SBS)

Other Products: Microsoft visual studio, Microsoft project, Crystal Reports, entire sweet of sql tools

Data Bases: SQL Server 2000-2014,Sybase, Access, Paradox, Informix

Languages: SQL,TSQL, Visual Basic,C#, VB.Net,Java, HTML

PROFESIONAL EXPERIENCE:

Aetna(Consultant)

09/16 – 01/17

Systems analysis: Worked with enterprise vault an archiving application to save disk storage. Developed a power shell application to monitor disk usage. Used PowerShell to collect daily disk sizes into a Sql database and wrote SSRS reports to report on results.

Wells Fargo(Consultant)

2/16 – 8/16

Security analysis. Provisioned database users for SQL server and Oracle. Utilized corporate ticket system to handle request. Followed Wells Fargo processes and procedures to control rights to over 1000 corporate databases. Used TIM, sql developer and sql server management studio to manage database rights.

GEO

7/15 – 2/17

Developed an MMO using SQL backend, Dot net clients, web portals and web services. Created SQL databases and all the objects. Created game clients using visual studio, C#, vb.Net. Created and maintained web pages and services with IIS.

Waste Management(Consultant)

01/15 – 6/15

Oracle & SQL server DBA. Developed a system to monitor disk utilization using SQL backend and power shell

Transperfect Remote Interpreting

11/12 – 11/14

Software engineer\DBA\Dot Net developer. Responsible for all aspects of applications systems development and maintenance. Introduced a corporate address book, Customer portal and TERP (Transperfect Enterprise Resource & Planning).

Arizona Dept. Game & Fish

12/08 – 11/12

Dot.Net Developer/DBA. Responsible for Sql Server administration and desktop application/development. Created multiple windows and web apps including eservices portal, conservation education database, consolidated customer database, AFIS reporting system, water catchment database.

Customer Funding

09/06 – 12/08

SQL Server DBA/Data Base Developer. Maintained high transaction data bases including all the data base objects, procedures, triggers, function and user right. Created web application using Visual Studio 2005. Designed and lead a team of programmers in the development of an enterprise accounting system including accounts payable, accounts receivable, and general ledger with a complete set of financials. Wrote numerous report with Crystal reports 11.0

Heritage Mint Ltd

10/05 – 8/06

IT Manager Implemented Gentran EDI system. Created time card, asset manager, employee systems and sales/invoicing system all utilizing Visual studio 2005. Administered SQL Server data base, backup recovery, all database objects. Created SQL server instances, established table spaces on a RAID server. Created users, roles. Wrote database procedures, triggers and views. Crystal Reports 8.5

Goodrich AIP

10/03 – 10/05

Oracle DBA on Windows platform. Manage multiple oracle data bases, backup recover, user rights. Created indexes, packages, procedures, views and triggers. Established PL/SQL programming standards. Applied updates to database and ERP System. VB developer. Developed a number of vb apps including a time card system. Crystal reports ver 10.x.

Next Generation Systems

01/01 – 10/03

Senior Software Engineer. Created a core system of active X components used in the development of software systems. Created active server pages for their web enabled business applications. Served as their Oracle/Access/Sql Server DBA on Windows platform and web administrator. Created databases, set up table spaces, users and monitored database performance.

Honeywell Corp

11/00 – 05/01

Oracle developer. Created process to load aircraft historical data from FoxPro database to an Oracle 8i database. Utilized visual basic, Oracle packages and procedures and Oracle 6i forms.

Apollo Group Inc.

7/99 – 9/00

Maintained student information systems. Developed and maintained over 50 4.5 forms. Created and maintained numerous PL/SQL packages, triggers sequences and all related data base objects. Wrote and maintained PRO/C reports. Developed Oracle programming standards for PL/SQL & Forms. Established PL/SQL and Oracle coding standards.

Oracle

10/98 – 4/99

Senior Consultant

Oracle Apps (Financials)

Reports 2.5, Forms 4.5, PL/SQL

Created custom reports and forms for Oracle Financials.

ADHS

10/97 – 10/98

Project Leader

Managed 4 different projects and 3-5 programmers. Prepared project plans and maintained status reports for upper management. Provide technical expertise for both programmers and users. Designed the Issues Tracking System utilizing Designer 2000. Created the data base, all the data base triggers and procedures. Designed all the forms and reports utilizing Designer 2000, Forms 4.5 and Reports 2.5 working closely with the user community.

ADHS

10/95 - 10/97

Programmer/Analyst

Migrated the Birth Defects Registry from a COBOL system on the Bull to an Oracle 7 data base utilizing Designer 2000. Wrote migration programs to convert data to new format utilizing SQR. Developed reports utilizing SQR. Assisted in the design of the system from the ground up using Designer 2000. Created data base triggers, procedures and functions.

ADOT

10/94 - 10/95

Programmer/Analyst

Worked with a team of consultants and FTE’s to create the freeway management system in Phoenix. Utilized C and DBUIMX on a Sybase database.

Contact this candidate