SQL Server DBA/ Developer Resume Plano, Texas - Hire IT People

AREAS OF EXPERTISE:

Database: SQL Server 2005/2008 R2/2012/2014 Enterprise/Management Studio, MySQL, Sybase SQL, T - SQL

Performance Tuning: Capacity Planning

Installation, Upgrade & Migration: ODBC, OLE DB, DTS, SSIS, SSRS, SSAS

Applications, softwares: Erwin R8, ER Studio, UML, TFS, Sharepoint, QlikView, Tableau, Microstrategy

Visual Studio: 6.0/.NET, Performance Point Server2007, Client / Server, IIS

Language: Python, C/C++, .NET, HTML, XML, ASP, JSP, JavaScript, MDX

Protocols: HTTP, TCP/IP, FTP

WORKING EXPERIENCE:

Confidential, Plano, Texas

SQL Server DBA/ Developer

Responsibilities:

Designed and implemented a snowflake - schema Data Warehouse in SQL Server/ MySQL based on the existing data warehouse & operational database.
Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamically so it fits the environment.
Managed existing and developed new ETL processes for SQL Server reports refreshing &data loading Processing. Scaled SSIS to make it work more reliable.
Wrote enterprise reports and stored procedures upon requests. Designed report models to meet business requirements and allow users to perform fast queries.
Scheduled and monitored all maintenance activities of SQL Server 2008R2/2012/2014 to meet business requirements activities including database consistency check, data backup & restore strategy, recovery models, index defragmentation.
Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
Ran monthly end processes. Troubleshot issues in jobs, reports, SSIS packages and so on. Trained the business users to create Ad hoc reports of their own.
Other DBA duty includes high availability/disaster recovery resolutions, like replication, mirroring, log shipping. DBCC commands.

Confidential, Charlottesville, VA

SQL Server Developer

Responsibilities:

Scheduled and monitored maintenance activities of SQL Server 2008/2012 to meet business requirements activities including database consistency check, data backup & restore strategy, index defragmentation.
Managed the production, development, and test database including access controlling, high availability, performance monitoring and tuning, capacity planning.
Maintained SQL Jobs which refresh Data Warehouse, process cubes, and backup databases.
Modified and tuned SSIS packages, and changed cube designs to accommodate business changes.
Migrated the databases, cubes, SSIS packages from SQL 2008 to SQL 2012 based on the business requirements.
Created new SSIS packages, standard tables and scheduled jobs to support reporting needs.
Created, managed, and delivered interactive web-based reports for SharePoint Dashboard to support daily operations.
Created and customized SharePoint KPI lists for key business metrics using SharePoint designer.
Monitored the status of all databases and servers including CPU, memory, I/O, space management, block, and dead lock.
Tuned performance, optimized databases, managed system securities, tracked logs and issues.
Python parsed data in a standard format in order to be imported into SQL Server and MySQL.

Confidential, Omaha, NE

SQL Server Developer/DBA

Responsibilities:

Database planning in relation to physical and logical data architecture.
Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
Designed and facilitated the implementation of data warehouses required by application systems.
Developed and maintained data methodologies, procedures, and standards. Performed data impact analysis. Properly maintained core or control application tables.
Modified database structures as directed by developers for test/develop environments and assisted with coding, design and performance tuning.
Designed a database cluster to handle more than one million OLTP transactions.
Upgraded existing SQL Server 2005 to SQL Server 2008.
Installed, configured and managed SQL 2008 Servers, migrated existing applications/jobs/maintenance plans to SQL 2008, transferred/re-wrote DTS packages to SSIS programs.
Managed user access. Created and managed new security accounts.
Backup and restored databases; developed backup strategy and restore procedures.
Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
Deployed, monitored, and maintained SSAS services and databases.
Assisted with various ad hoc query requests.
Provided back-end support for functional testing and performance testing.