SUMMARY:

• A professional SQL Server 2012/2008/ 2005 Database Administrator and Developer with significant experience in design and development of databases.
• Exposure to financial, accounting, medical, logistics, security and telecom applications. Experienced with SAN, RAID, and Supported Clusters (software and Microsoft).
• Experience with VM databases, log shipping and mirroring, merge and transactional replication. Managed performance using new features of SQL Server, SQL third party tools and PowerShell scripts.
• Exposure to Data Warehousing, DataMart implementation and ETL. Motivated and results - oriented team player who works effectively with minimum supervision. Automated several manual operations using PowerShell and T-SQL. Strong analytical and problem solving abilities. Comfortable working in High Availability 24/7 operations. Worked with networks, security, mapping, remote access, automation and monitoring with a desire to improve and contribute in all areas of teh business.
• SQL Server 2005/2008/2012
• Installed, Updated, Managed, monitored and troubleshoot all production, development, and test databases, ensured adequate capacity
• Reorganization and rebuilding indexes for defragmentation
• Leveraged Profiler and watched events, and queried DMV,DMO, PowerShell for solutions to performance problems.
• Performed Monitoring on several hundred SQL Server databases using Nimbus, longitude, PowerShell, SQL sentry
• Formatted disk partitions
• Maintained clusters, log shipping, transactional and merge replication and Mirroring, SSRS,SSIS,SSDT
• Developed, reviewed, and supported SQL code for accounting, research, auditing
• Created diagnostic scripts to see who was doing wat and using wat resources to give valuable information on wat is really going on, quickly
• Used several features such as resource governor, reporting services, Policy based management and advanced T-SQL queries
• Troubleshoot application issues, space issues and improved database performance
• SSIS ETL with data moving and cleansing.
• Setup merge replication
• Used Perfmon (paging, me/o and CPU information), profiler, task manager and various counters for base lining and improving performance
• Fixed suspect databases and corrupted data
• Used Query Optimizer and DMV to tune T-SQL and stored procedures
• Preformed backup and restore databases and scripted to “automate” database restore scripts.
• Worked with SAN and RAID and Virtual environments.
• Worked with developers setting up indexes, replications, and tuned T-SQL and developed stored procedures
• Tested SSIS,SSDT ETL, creating tables and business relationships
• Document database environment
• Worked with Oracle 8i/9i/10g, MySQL, a little DB2 and Teradata
• Resolved space issues, long running transactions, deadlocks, blocking, runaway transactional logs, open transactions and temp database space issues.

TECHNICAL SKILLS:

Technical: SQL Server 2005, 2008, 2012 T-SQL, SSIS,SSDT, SSRS and events, C# .net, ADO, XML, C++,VB .net, Java, C, OOP,OOD, OOA, Microsoft Word, Rational Rose UML analysis, Perl, VB scripts, Crystal Reports, PowerShell, Remedy Developer

Vendor Systems: Microsoft Windows, Clearcase, Rational Rose, SQL Compare, Spotlight, Foglight,SQL Sentry, Ignite, DBArtisan, Litespeed, SQL Safe, SQL Backup Pro, Native Backups (compression, buffer, file groups) Management Studio, Visio, Rational Rose UML

PROFESSIONAL EXPERIENCE:

Confidential - Garland, Texas

Database Administrator

Responsibilities:

• Completed over 30 accounting, service and labor reports
• Verified teh data in teh reports prior to release
• Monitored several databases dat maintain accounting and finance data
• Performed database optimization, administration and maintenance
• Created complex SSRS reports and code to monitor and refine company
• Saved teh company teh expense of several contractors of various applications.
• Saved teh company from disaster one of which happened on my day off, 25 June 2014 and several other close calls due to my effective monitoring,
• Often acnoledged by managers, accountants, project managers and teh owner for teh value of my work to teh company saving time and allowing teh correct decisions to be made on information dat was not readily available in one output form
• Improved teh company profits and identified potential problems as well as solutions
• Saved accounting workers and project managers hundreds of hours of work time.
• Fixed several coding problems consultants left behind, giving teh company an advantage over their competition.
• Worked with integration services and experimented with database products.
• Modeled and documented database ERP relationships.

Confidential - McKinney, Texas

Senior Database Administrator

Responsibilities:

• Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005,2008,2012 for hundreds of databases
• Worked with replication of databases
• Supported hundreds of databases, automated many task with power shell
• Launched several power shell scripts to monitor and report accurate and fast information dat was not currently available by any other means.
• Troubleshooting problems and performance monitoring SQL Server Database server
• Used power shell to obtain information from hundreds of servers and report back in less than two minutes.

Confidential - Irving, Texas

Database Administrator

Responsibilities:

• Designed, installed, supported SQL Server 2008 r2 in a SSIS staging environment with an SSRS report writing environment.
• Worked with MYSQL databases as in conjunction with SQL Server
• Set up capacity planning reports and several other reports and automation.
• Set up and supported replication.
• Created and tested SSRS reports from a mysql data warehouse
• Performed ETL and purging projects using SSIS and SQL scripts.
• Tuned slow queries, added indexes, removed indexes and provided faster ways to obtain information.
• Provided stored procedures to find and list join order information for best first, second, and third degree of separations based on specific column names.
• Provided Enitiy relational Pk-Fk representation of all tables within minutes.
• Wrote stored procedure to record distribution and cardinality of all tables.
• Wrote queries to match values to tables in order to find wat tables contained teh needed research information in 23 seconds. Moved data into and out of SQL server to several types of databases.
• Imported a data warehouse data into SQL server.
• Solved many unusual problems.
• Resolved confusion in order to increase data consistency
• Installed reporting services. Wrote scheduled reports and subscribed users to reports
• Used power shell to overcome teh discrepancies of SSRS subscriptions.
• Presented idea dat saved company over $100,000 per month.
• Worked with several mySQL 5.6 databases as well.

Confidential - Addison, Texas

Database Administrator

Responsibilities:

• Wrote several SSIS packages for development and production BI projects
• Helped several developers with their SSIS packages and t-SQL code
• Automated several task including unzipping files
• Installed SSRS and wrote and fixed SSRS report problems
• Found logical problems in code and SSIS packages
• Discovered performance problems in code and SSIS packages
• Turned in over 30 s in first 90 days of work.
• Upgraded SQL server and applied patches
• Installed 2008 r2 SQL server instances, set up jobs, installed memory
• Wrote several power shell scripts to automate jobs and gather information quicker
• Documented databases, several problems and step by step solutions
• Set up some BI models to show developers Pk to Fk relationships
• Set up jobs for SSIS packages, using checkpoint, passwords, configuration files
• Set up SSRS jobs and reports, Fixed problems with scheduler and permissions
• Fixed several transactional replication problems
• Presented Problems, their Solutions and Rationale for teh solutions and implemented them

Confidential

Database Administrator

Responsibilities:

• Evaluated and documented suggestive changes to improve database performance.
• Ran backups and set up new databases for development
• Improved several queries and added indexes to databases
• Added improved configuration settings to speed queries
• Supported 2005/2008 r2 SQL servers

Confidential - Irving, Texas

Database Administrator

Responsibilities:

• Accomplished merge replication installing publications and repairs
• Applied log shipping, merge replication and database mirroring
• Spotlight, Enterprise manager and Management Studio, Litespeed
• Backup and restored databases to different file groups and files, Detached and Attached databases to move files, fixed orphan users
• Worked with Oracle databases with SQL Server databases
• Created some SSRS reports
• Allocated permission, installed scripts, created jobs, resolved redundancy issues.
• Tuned T-SQL queries and stored procedures
• Set up maintenance jobs for DBCC checks, reorg, re-indexing, statistic updates
• Checked error logs in SQL Server and system, checked cpu usage, io latency, network latency, moved tables and data across databases and environments
• Purged tables with millions of rows
• Documented several new ideas and methods of task
• Built jobs for reporting runaway jobs and invalid users
• Solved several complex problems and supported vendors
• Fixed log shipping errors, and suspect databases
• Fixed DTC problems causing redundancy issues.
• Fixed orphan users and connections, and stored procedures added memory in 32 bit and 64 bit servers
• Automated jobs and applied script automation
• Fixed Report Builder 2 and created SSRS reports
• Used Profiler, and 2005 DMV views for finding problems
• Resolved application problems

Confidential

Senior SQL Server DBA

Responsibilities:

• Moved data across databases and environments.
• Maintained clustered databases
• Distributed monitoring and reporting scripts
• Researched and gatheird data for best migrations
• Tuned T-SQL queries and stored procedures
• Set up maintenance jobs for DBCC checks, reorg, re-indexing, statistic updates
• Fixed orphan users and faulty stored procedures
• Set up Reporting services on 32 bit OS
• Worked with Oracle databases 8i,9i,10g with SQL Server
• Solved several complex problems and supported vendors
• Automated jobs and applied script automation
• Checked for allocation, torn pages, fragmentation, parallelism problems
• Used Profiler, Read80trace and 2005/2008 DMV views for finding problems
• Applied application migration including indexes, triggers, d-links, compiling options, running SSIS packages, and merge replications

Confidential - Dallas, Texas

Database Administrator

Responsibilities:

• Set up and tested packages to transform and move data.
• Moved data between SQL Server and other databases
• Determined problems and made solutions to them.
• Provided QC with test conditions and predetermined results for testing packages and stored procedures.
• Set up development databases for production testing.
• Tuned stored procedures and packages for better performance.
• Fixed a suspect database

Confidential - Dallas, Texas

System Database Administrator

Responsibilities:

• Created and installed multiple databases, scripted logins.
• Wrote scripts for tape and disk backup
• Supported projects with PeopleSoft, Remedy, Medical and Financial applications.
• Evaluated performance of various databases
• Experienced with clustering
• Distinguished between database, application, network, disk array, dtc, paging, io, tape management problems
• Handled “priority one” problem without computer or any resources over teh phone my first hours on teh job
• Supported clustered databases
• Remedied blocking and locking and deadlock issues.
• Worked with VM databases (SQL Server 2000/2005, oracle 10g)

Confidential - Richardson, Texas

Database Contractor

Responsibilities:

• Validated logical data models with business subject matter experts
• Analyzed, and transformed business requirements into logical data models and applied changes to customer upgrades
• Performed Application tuning, load test optimization
• Provided well timed assistance and advice to multi-billion dollar companies. Including travel to customer site.

Confidential - Irving, Texas

Backup DBA / Programmer

Responsibilities:

• Performed Application tuning
• Performed database monitoring and ran maintenance scripts
• Established policies and procedures for database management
• Lead for SQL Server 2000 and 2005 databases
• EMC cluster storage
• Performed data replication
• BCDR designed / tested for disaster recovery

Confidential - Plano TX

Software Developer Engineer

Responsibilities:

• Designed a Database for keeping up with distributed database.
• Acquire, analyze, and transform business requirements into logical data models
• Optimized database code