Database Specialist Resume Chicago, IL - Hire IT People

Motivated Software Engineer with education and experience in Computer Information Systems
seeking a position utilizing my expertise in all phases of SDLC

Summary of Qualifications

3+ years of Software Development experience in all phases of life cycle, including requirements gathering, project planning, scheduling, coding, testing and reporting.
Extensive knowledge in Tuning SQL queries and improving the query performance using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
Skilled in planning and implementing MS SQL server security and database permissions, as well as expertise in generating reports using SQL Server Reporting Services and Excel spreadsheets.
Knowledge of NoSQL platforms; Hadoop stack (MapReduce, Sqoop, Pig, Hive, Hbase, Flume) ; statistics and machine learning
Knowledge of ETL and Microsoft Business Intelligence Stack: SSIS, SSRS, SSAS
CompTIA Security + Certified

Technical Skills

Internet: Asp.net, Ado.net, JavaScript, Ajax, PHP, Html, Css, Dhtml, Xml,Xpath,Xsd, Xhtml, Xslt, Web Services, Soap, IIS, Web 2.0 Technology, Apache
Languages: C#, C++, Java, VB.net, UML, OOP, shell scripting, Multithreading
Operating Systems: Linux, Unix, Solaris 9, Windows (NT/2000/XP/Vista)
Development Tools: SQL Profiler, SQL Query Analyzer, Management studio, Index Analyzer, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, MySql/PhpMyAdmin , Eclipse, MS Visual Studio, Net Beans, Rational Rose, Microsoft Visio, Windows Power
Shell, Share Point 2007
Databases: MS SQL Server 2000/05/08, MySQL, Oracle 10g, MS Access 2000/2007 and RDBMS's, stored procedures, database objects, triggers, backup and recovery, ETL, DB design, replication, SQL profile, SQL Query Analyzer, SQL Agent, SQL Alerts, SQL Jobs, DB upgrade, Windows Powershell, mirroring, BI (SSIS, SSRS, SSAS)

Professional Experience

Junior Database Specialist
Confidential, Amman, Jordan 06/2009 - 07/2012

Responsibilities:

Wrote stored procedures for application developers and some user defined functions
Created Triggers to enforce data and referential integrity
Defined Check constraints, Business Rules, Indexes, and Views.
Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Created Alerts for successful or unsuccessful completion of scheduled Jobs.
Created error and performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
Used SQL Server Reporting Services to generate different types of Ad-hoc reports.
Configured SQL Mail agent for sending Automatic emails
Used T-SQL to create store procedure Indexes, and Views; managed users, roles and groups; defined check constraints
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning. Creation/ Maintenance of Indexes for various fast and efficient reporting processes
Wrote stored procedures for Application Developers and some user defined functions, created Triggers to enforce data and referential integrity, and defined Check constraints, Business Rules, Indexes, and Views.
Regularly monitored the system for bottlenecks and suggested/implemented solutions.
Performed tuning of SQL queries and stored procedures using data generated from SQL Profiler.
Developed ASP and PHP web sites supported by SQL 7.0/ 2000 and MySQL database servers as back-end.

Technical Environment: SQL Server 2005/2008, Stored Procedures, SSRS, SSIS, ETL, T-SQL, DDL/DML, SuSE 10, Fedora, RHEL 4/5, Windows 2003/08 Server, ASP.net, IIS6

Education

B.S. Information Systems

Keywords: SQL, PL/SQL, Hadoop stack, MongoDB, Object Oriented Analysis, OOA, Object oriented Design, OOD, Unified Modeling Language, UML, Rational Unified Process, SDLC.

We provide IT Staff Augmentation Services!

Database Specialist Resume

Chicago, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship