Sql Server Management
Resume:
JORGE I. GIRALDO
*****.*******@********.***
SUMMARY
Highly motivated SQL Developer/DBA with experience using SQL Server
Management Studio and Visual Studio 2008. Demonstrated leadership
abilities and team work skills as well as the ability to accomplish
tasks under minimal direction and supervision. Demonstrated excellent
verbal and written communication skills when communicating with all levels
of management. Possesses excellent work ethic and great problem solving
skills, as well as the ability to interact with co-workers in a
professional manner in different situations.
TECHNICAL SKILLS
Database Management Systems:
Microsoft SQL Server 2008
Software:
MS SQL Server 2008 Integration Services (SSIS), MS SQL Server 2008
Reporting Services (SSRS), MOSS 2007, Microsoft Office
Tools:
SQL Server Management Studio, Microsoft Visio, Database Engine Tuning
Advisor, SQL Server Profiler
SetFocus, LLC. Hackensack, NJ 1/10 - 03/10
SQL Master's Program
. Created numerous simple to complex queries involving self joins,
correlated subqueries, CTE's 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, and implemented the import and
export 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 SSRS 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.
. Created an ETL solution that reads Product, Vendor, and Order data
from an FTP server into a SQL Server database. The solution also
validated incoming data and performs notifications when jobs
complete. The order data thus loaded into SQL Server was used to
generate reports and charts using the new SSRS 2008 reporting
functionality (Tablix control, new charting features). The reports
were set up for automatic delivery based on data-driven report
subscriptions.
. Installed MOSS 2007 and configured an intranet portal that contains a
wiki and a site template accessible to only authorized groups
according to business specifications.
. Implemented numerous backup and recovery plans based on data
availability requirements and the potential impact of data loss after
considering and analyzing 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.
. Utilized tools such as SQL Server Profiler, Activity Monitor,
Performance and Reliability Monitor, Data Collector, Policy-Based
Management, Resource Governor, Event Notifications to monitor and
ensure optimal performance of SQL Server.
. Analyzed different high availability solutions and implemented log
shipping, database mirroring and replication.
. Familiar with employing Service Brokers.
PROFESSIONAL EXPERIENCE
Bank of America Newark, NJ 4/07 - 10/08
Bilingual Collector
. Contacted Spanish speaking customers throughout all stages of
delinquency.
. Used various skip tracing tools in order to successfully collect
payments and bring credit card accounts up to date.
. Educated and qualified delinquent card holders for payment plans and
account settlements.
New Mexico Highlands University Las Vegas, NM 6/05 -8/05
Software Developer
(Internship)
. Responsible for helping Software Development team
create web-based inventory system for a local Business using
Small Talk.
. Responsible for maintaining the MySql database and Linux Server.
New Mexico Highlands University Las Vegas, NM 6/03 -8/04
Marketing Research Assistant
(Internship)
. Assisted team in developing a marketing plan to revitalize Route 66 in
the State of New Mexico.
. Set up focus groups to gather historic information from community
members for Route 66 project.
. Developed Access database to track contacts.
EDUCATION
New Mexico Highlands University Las Vegas, NM 5/09
Masters of Business Administration
(M.B.A.), in Management Information Systems - Overall GPA 3.2
New Mexico Highlands University Las Vegas, NM
Bachelors of Arts, Management Information Systems - Overall GPA 3.4
Major GPA 3.4 Minor Music Performance
Languages Spoken
Spanish
Contact this candidate