Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Oakland, CA
Posted:
April 24, 2016

Contact this candidate

Resume:

Michael O.

Sql Developer

Oakland, CA

Authorized to work in the US for any Employer

Cell: 734-***-****

acuhde@r.postjobfree.com

Summary

Around 3+ years of experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2012 environment.

As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.

Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.

Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.

Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.

Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report using SSRS to develop Drill-down,Drill-through And Cascading reports.

Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Technical Skills:

RDBMS/DBMS:

Microsoft -SQL Server 2012/2008R2/2008/2005/2000, MS Access.

BI /Data model Tools

Microsoft SQL Server Reporting Services 2008R2/2005/2000, Crystal Reports, DTS, SSIS, Erwin And Visio. Visual Studio 2013/2015

Programming Languages:

T-SQL, Visual Basic 6.0, SQL * Plus.

Application Packages:

MS Office, MS Outlook. Power Query, PowerPivot,

Database Tools:

SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Team Foundation Server(TFS) Proficient, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

EDUCATIONAL DETAILS:

Bachelors of Science University of Lagos, Nigeria 2008, Mathematics And Statistics

PROFESSIONAL EXPERIENCE

JDA Software, Scottsdale, AZ Jan 2016 till Present

Sql Developer

Responsibilities:

Created T-SQL Queries, Dynamic Queries, Sub-Queries and Power Query

Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.

Worked on migrating DTS packages and Metadata Management

SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Created SSRS reports to develop Drill-down, Drill-through and cascading reports.

Did Performance tuning on SQL Server 2008R2 and 2012

Randstad Technologies Scottsdale Az.

Go Daddy, Scottsdale, AZ July 2015 to Dec 2014

Sql Developer

Responsibilities:

Created XML scripts that pulled data from CSV file into SQL server, Created Stored procedures to meet business rules on the data pulled into the database, Also Created PowerShell Scripts that call both the Application (VDI) and the SQL scripts to populate the Destination table. All was ran on a Task Scheduler

Wrote T-SQL Queries, Dynamic Queries, Sub-Queries and complex joins for generating complex Stored Procedures, User-Defined Functions, Views and Cursors.

Modified Stored Procedures, Triggers, Tables, and Views. Re wrote processes to get data from one server and database to another databases.

Experience in using SSIS Tools like Import and Export wizard, Package Installation, and SSIS Package designer

Transformed data from one server to another server using Bulk Copy Program(BCP), and SQL Server Integration Service (SSIS)2008/2012

Highly efficient with writing parameterized queries, drill through reports and SQL Server Reports in SSRS 2008/2008R2

Created Change Order to Deploy Scripts from one environment to the other, usually from Development to Test and to Production

Highly Proficient and efficient with the Visual Studio 2015 Team Foundation Sever Tool(TFS)

Highly efficient with the Report manager Tool to generate reports for the Accounting team and across all environments

Created Spreadsheet reports using Power query tool, pulling data from different data sources for the senior level management.

Created SQL Agent Jobs to run at a specific time to carryout different purposes e.g. populating a table for report purposes, generate reports for the management etc.

Environment: MS SQL Server 2008 R2/2012, Visual Studio 2013/2015, Power Query Tool, Team Foundation Server (TFS), SQL Agent, Power Shell, SQL Profiler.

BATechnolinks, Santa Clara Ca.

Persistent Systems, Dublin, OH Dec2014 – June 2015

Sql Developer

Responsibilities:

Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Creating Database objects – Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.

Created New Databases, backed up and Restored previously created databases within and outside a server.

Highly Proficient and efficient with the Team Foundation Sever Tool(TFS), Element Tool(ET) and code delivery process to client

Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements.

Deploying new Database objects in production environment.

Bug fixing, script optimization and process enhancements that where database related

Coordinating post-implementation events such as Deployments, testing and validation of Scripts

Worked closely with the Application team to understand business requirement and develop Database objects or Procedures to meet the new requirements

BATechnolinks, Santa Clara Ca.

American Express (GBT), Phoenix, AZ July 2014 – Dec 2014

Sql Developer

Responsibilities:

Worked as a lead database and SQL developer, did extensive work on creating partitions on tables, creating relational databases.

Migrated DTS packages from 2000 to 2005 and to 2008 SQL Server and also modified Stored Procedures to comply with the current versions of SQL Server.

Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.

Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.

Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.

Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Worked extensively with the Business Analyst using the Rally to create user stories based on the business requirements.

Created and Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements instead of Cursors in T-SQL

Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Integration / Reporting Services 2012 OLTP

BATechnolinks, Santa Clara Ca.

FI$CAL–State of California, Sacramento, CA Jan 2014 – July 2014

MS SQL Server T-SQL/SSIS Developer

Responsibilities:

Worked as a lead developer and also worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into Sql server.

Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs

Creating Database objects – Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement

Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports

Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications

Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility

Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques

Generated parameterized reports, sub reports, tabular reports using SSRS 2008.

Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.

Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.

Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.

Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Integration / Reporting Services 2012 OLTP.

BATechnolinks, Santa Clara Ca.

Countrywide Home Loans, NY Jan 2013 – Dec 2013

Jnr SQL Developer

Responsibilities:

Involved with Installation, Upgrade and Troubleshooting of MS SQL Server 2005.

Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.

Designed, Developed and maintained Relational databases.

Worked in creating Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Running Index tuning wizard and rebuilding indexes for faster query response.

Responsible for SSIS activities to move data from text files to SQL Server.

Scheduled SSIS Packages daily and weekly Basis.

Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.

Ensured developers coordinated their efforts in managing and maintaining different application databases.

Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.

Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.

Environment: Windows 2000 Advanced Server, SQL Server 2000, 2005, 2008, MS Outlook, FTP, TSQL.



Contact this candidate