Post Job Free

Resume

Sign in

Sql Server administrator / Developer

Location:
Hallandale Beach, FL, 33009
Posted:
February 09, 2017

Contact this candidate

Resume:

Juan C. Arellano

Hallandale Beach, FL *****

LinkedIn • 786-***-****• acyq1m@r.postjobfree.com

Database Administrator/Developer

Dual discipline technical career with 15+ year track record of success

Knowledgeable, bi-lingual (English and Spanish) database administrator and developer with over 15 years’ experience installing, configuring and maintaining database servers. Skilled in backup and recovery, virtualization and consolidation, and maintenance to ensure optimum performance. Understand the importance of collaborating with business units and other IT teams to make certain all database needs are met. Proficient in application development. Consistently meet production deadlines.

Database Design / Database Programming / Backup and Recovery

Exceptional Problem Solving / Excellent Communicator

TECHNICAL PROFICIENCIES

Database Programming:

Triggers, Stored procedures, T-SQL, user defined functions, C, C++, ASP.Net, C#, Visual Basic, Java, and JavaScript

OS’s:

MS Windows Server, MS Windows 3x/9x, XP, Vista, MS DOS

Server Applications:

MS-SQL Server 2000, 2005 (MCTS), 2008, 2012 (DBA/Developer), SSIS, SSRS, SSAS, MS- Internet Information Server, Crystal Enterprise Sever, Hyperion Server, MS-SQL Server 7 (MCP).

Internet Technologies:

VBScript, Jscript, Active Server Pages (ASP, ASP.Net), HTML, XML, DHTML.

PROFESSIONAL EXPERIENCE

Database Administrator/Developer (3/2009 – 1/2017) Seminole Tribe of Florida, Hollywood, FL

Technical Scope: Microsoft SQL Server 2000, 2005, 2008 and 2012, MS-SQL Server, Hyperion, Crystal Enterprise Server, SSIS, SSRS.

Gave meticulous attention to preventative maintenance and upgrades to ensure system and data availability, and integrity. Successfully accomplished installation, configuration and maintenance of database servers on SQL Server 2005, 2008 and 2012, and deployed SSRS reports. Gathered requirements from business units for reporting needs, ad hoc queries, ETL processes, stored procedures, etc. Executed migrations to accommodate vendor version upgrades and benefit from new functionality (virtualization, clustering and availability). Re-designed and re-wrote database objects, and re-wrote existing Crystal Reports into SSRS which ultimately saved the organization the cost of annual licensing and support for the Crystal platform.

Key Achievements:

Designed, developed and deployed a data warehouse for consolidating financial and tax information to produce reports and annual statement of benefits for all Tribal members. Created a full set of BI reports in SRSS (using Lawson BI) and integrated data from the Hyperion planning platform for the budget team, eliminating the need to buy reporting module from Hyperion. Virtualized and consolidated multiple servers.

Crafted design (logical and physical), developed and implemented databases for new internal systems and applications.

Deployed database tuning and optimization, backup and recovery policies/procedures, replication and security (collaborated with other teams) for all database servers to assure high availability and peak performance of data driven applications.

Volunteered to spearhead the ERP development team to upgrade entire system to a newer version (Infor Lawson). Stepped up as development team lead and managed a successful migration.

Software Engineer (5/2001– 1/2009) GO2TEL.COM, Inc., Miami, FL

Technical Scope: MS SQL Server 2000 and 2005, DTS, SSIS

Performed logical and physical database design and implementation on SQL Server 2000 and 2005; as well as installation, configuration and maintenance of database servers. Handled database migration from SQL Server 2000 to 2005; and the migration of DTS packages into SSIS. Developed and deployed the company’s billing and LCR system, and ETL processes (using DTS and SSIS). Collaborated with development team regarding authoring, report design, delivery and security using SSRS. Managed parallel tasks including server administration, Windows LAN, and help desk.

Key Achievements:

Developed application for principal reporting and monitoring system for high-volume wholesale telephony carrier traffic, in addition to other applications.

Implemented replication, database tuning and optimization, backup and disaster recovery procedures to ensure readiness and optimum performance of internal data-driven applications.

EDUCATION AND TRAINING

Bachelor of Science in Computer and Information Systems

Escuela Politecnica del Ejercito (ESPE), Quito, Ecuador

Technical Certifications

Microsoft Certified Technology Specialist (MCTS), MS SQL Server 2005 Implementation & Maintenance

Microsoft Certified Systems Professional (MCP), Designing & Implementing Databases with MS SQL Server 7

Professional Development

Windows DNA Architecture



Contact this candidate