Sql Server Engineer

REYNALDO J. FADRI

Canyon Country, CA *****

Mobile Phone 818-***-****

E-mail – ******@*****.**.***

PROFESSIONAL SUMMARY

• Highly motivated SQL Developer/DBA with experience using SQL Server Management Studio and

Visual Studio 2005.

• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under

minimal direction and supervision.

• Experienced Windows Systems Engineer in all aspects of designing, implementing and

troubleshooting Microsoft Networks.

• Productive self-starter with a strong work ethic and the ability to learn new technologies

independently.

• Adaptable and proficient in the design and programming of systems in a wide variety of areas.

LINKEDIN PORTFOLIO: http://www.linkedin.com/in/rfadricasql

TECHNICAL SUMMARY

• Certifications: Microsoft Certified Systems Engineer (MCSE) for Windows 2000 and NT.

• Programming Languages: Transact-SQL; Visual Basic for Applications

• Microsoft Technologies: SQL Server 2005 Reporting Services; SQL Server 2005 Integration Services;

Active Directory; TCP/IP; DNS; DHCP; DFS; Group Policies; Terminal Services

• Relational Database Management Systems: Microsoft SQL Server 2005/2008

• Operating Systems: Windows 2003 Server, 2000 Server, NT, XP, 9x

• Software: SQL Server Management Studio, Microsoft Visio, Database Engine Tuning Advisor, SQL

Server Profiler; MS Access; MAS90/200; Crystal Reports; ACCPAC; BackupExec; Anti-Virus;

Symantec Ghost; MS Office; Adobe Acrobat/Photoshop; Various Client/Server programs

• Skills: Network/Hardware/OS troubleshooting; Scripting; PC Assembly; Technical Support; Customer

Service Helpdesk; RAID Hardware

CURRENT COURSE WORK

SETFOCUS, LLC.

CANYON COUNTRY, CA

Master’s Program – SQL, 3/2009 - 5/2009

• Created numerous simple to complex queries involving self joins, correlated subqueries and XML

techniques for diverse business requirements. Tuned and optimized queries by altering database

design, analyzing different query options, and indexing strategies.

• As part of a team, analyzed the business requirements and systematically designed a database for an

online-movie (DVD/Blu-Ray) rental company. Employed best practices in creating a complete schema

including tables, relationships, stored procedures, views, clustered and non-clustered indexes and

triggers. Implemented the importation and exportation of data using XML and SSIS.

• As part of a team, created various reports according to the business requirements for the movie rental

company. Individually authored, installed, deployed and managed reports using SQL Server 2005

Reporting Services for a library database.

• Individually designed a bank application according to business requirements, and implemented robust

stored procedures, functions, and triggers to implement required functionalities.

• Designed stored procedures, functions and triggers to meet the needs of a pre-existing library database.

Developed a backup and recovery plan based on the data availability requirements of the library and

on the potential impact of data loss on the business after considering and analyzing the different

backup and recovery strategies.

• Designed database maintenance plans to set up core maintenance tasks to make sure that the database

performs well, is regularly backed up in case of system failure and is checked for inconsistencies.

• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and

implemented its recommendations wherever appropriate.

• Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze

the performance of the stored procedures.

• Analyzed different high availability solutions and implemented database mirroring and replication.

• As part of a team, established security policy using windows domain accounts and implemented a

security strategy to protect against threats and attacks.

• Familiar with employing Service Brokers, enabling HTTP support and establishing Notification

Services.

• Worked on the ETL phase of a Labor Analysis Business Intelligence solution employing SQL Server

Integration Services to define imports of the data from diverse data sources and built scheduled

packages to define the integration flow and to log data error exceptions.

• Familiar with the new relational features of SQL Server 2008

EXPERIENCE

RENEURON / AMCYTE / VIVORX INC.

SANTA MONICA, CA

MCSE, MIS Administrator, July 1999 – September 2008

Maintained and supported a 50 node Windows 2000/XP network for a small bio-tech company

• Designed SQL Server databases for scientific analysis.

• Upgraded Compaq/Dell servers and workstations to Windows 2000.

• Configured and managed MS Exchange 2000 server with Outlook clients.

• Maintained Veritas Backup Exec backup software, printers, and user workstations.

• Re-structured IP address scheme using DNS, DHCP, WINS.

• Experience with installing and troubleshooting MAS90/200 accounting software, and Crystal

Reports.

• Maintained Lucent Tech. Intuity Telephone Systems.

Environment: Windows Server 2003, 2000, NT; MS Exchange Server; SQL Server 2000, 2005;

Windows XP, 2000, NT, 98; Veritas Backup Exec, MAS90, 200; MS Office Professional

SYNERTECH INTERNATIONAL / FRANKEL, LODGEN, LACHER, GOLDITCH, SARDI, & HOWARD CPAS

ENCINO, CA

Network/Computer Engineer, April 1998 - February 1999

Maintained and upgraded a Novell/NT network, troubleshoot various DOS, Windows 32/16 bit

programs

• Rollout and configured 30 new Windows NT computers using Ghost imaging software.

• Configured MS Exchange / Outlook messaging systems.

Environment: Windows NT Server; Novell Netware 3.1x; Symantec Ghost; QuickBooks and various

accounting programs.

NAT SHERMAN INC., NEW YORK, NY

CNE, Network Administrator, November 1996 - June 1997

Maintained Novell/NT network of a small mail-order light manufacturing facility

• Troubleshoot and upgraded DOS/Windows95 workstations, printers, and servers.

• Trained users with various programs such as MS Office, WordPerfect, and ACCPAC Accounting

software.

• Designed customer base information in Access and maintained daily/monthly backups.

Environment: Windows NT Server; Novell Netware 3.1x; ACCPAC; Windows95, MS-DOS

CTS GROUP, INC., NEW YORK, NY

CNE, Network/Computer Consultant, June 1996 - November 1996

Installed and configured Microsoft / Novell NetWare networking products

• Field technician to support hardware/software and printer problems.

• Provided training in Windows, various office suites, Internet, databases, etc.

• Installed modems, memory, network cards, scanners, hard drives and software.

Environment: Windows NT Server; Novell NetWare 3.1x; Windows NT/95; MSDOS

SIGNAL TRANSFORMER CO., INWOOD, NY

Design Engineer, June 1994 - June 1996

Quoted and designed custom transformers that would meet customers' specifications

• Worked closely with the MIS department to automate many engineering functions to reduce

paperwork.

• Helped support other engineers with document management software.

• Supported customers with transformer design and implementation.

Environment: Windows 95, 3.1x; AutoCAD and various engineering software

EDUCATION

SMART CERTIFY ONLINE TRAINING

MCSE Windows 2000 Training, Spring 2001

SMART CERTIFY ONLINE TRAINING

MCSE Training, Spring/Summer/ 2000

COMPUNET LEARNING CENTER, DOBBS FERRY, N.Y.

CNE Training, Summer/Fall 1995

POLYTECHNIC UNIVERSITY, HAWTHORNE, N.Y.

Course Work Completed Towards Computer Science Degree, Spring 1995-1997

Relevant Coursework:

Introduction to Operating Systems

MANHATTAN COLLEGE, RIVERDALE, N.Y.

Bachelor of Electrical Engineering, 1994

Relevant Coursework:

Electronics, Signals and Systems, Microcomputers, Digital Systems, Control Systems,

E.E./Digital Design, C Programming

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate