SQL Database Administrator Resume Richardson, TX - Hire IT People

SUMMARY:

Highly organized, solutions - oriented, and innovative professional with expertise in SQL database and server administration, specializing in SQL Server from installation to end-user support
Expert in systems analysis, disaster recovery, ETL tools, security management, and T-SQL scripting.
Expert in SQL Server Integration Services (SSIS) development and deployment, as well as SQL queries, process, and data modeling.
Armed with successful track record of spearheading implementations and next-generation technical solutions to improve revenue, margins, and workplace productivity.
Equipped with proven effectiveness in building motivated and productive teams.

AREAS OF EXPERTISE:

Data Transformation Services (DTS)
Software Development Life Cycle (SDLC)
Performance Tuning
Query Optimization
Client/Server Connectivity
Database Consistency Checks
Network Infrastructure
Reports Generation
Software Migration
Technical Troubleshooting

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows | Windows Server | MS-DOS | Red Hat Linux | VMware

Infrastructure service: DHCP | DNS | SMTP | FTP | TFTP

Installations and Troubleshooting: Hardware and Peripheral | Power Supply | OS Boot Recovery Console/Windows Recovery

Environment: Windows Server 2000/2008/2012 | Local Area Networking

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

SQL Database Administrator

Responsibilities:

Install SQL Server as per client requirements and lead the migration from SQL Server 2008 to 2014
Carry out the deployment of the SSIS package to SQL Server and file system in accordance with the requirement and scheduled SSIS package to run as a job
Utilize the available tuning methods for SQL Server databases, as well as define check constraints, business rules, indexes, and views
Take charge of developing a new SSIS package to extract date from legacy to SQL Server Objects through the use of Business Intelligence Development Studio (BIDS) and Visual Studio 2008
Use the SSIS in creating ETL packages for the validation, extraction, transformation, and loading of data to data warehouse and data mart databases
Ensure accuracy in preparing reports using SSRS 2008 and Excel (Pivot), which include sending of information to diverse group of users, clients, and managers
Assist in extracting data through SSIS from online transaction processing (OLTP) to online analytical processing (OLAP) as well as execute performance tuning of stored procedures and T-SQL queries
Assume several database activities, such as backup, restore, monitoring, and others; as well as define scope for new releases and help the business in resolving existing issues

Confidential, Irving, TX

SQL Database Administrator

Responsibilities:

Conducted installation, configuration, and version upgrades for SQL Server instances; managed the SQL Server data and transaction log backups; and upgraded the environment for SQL 2000 to 2005 and 2005 to 2008
Formulated and implemented security policies and procedures for database and reporting servers
Restored and recovered databases; automated database maintenance tasks; executed performance tuning optimization through SQL Profiler, Activity Monitor, Database Engine Tuning Advisor (DTA), Dynamic Management Views (DMV), and database indexes and statistics
Oversaw the SSAS cubes and developed SSIS solutions to automate recurring manual processes; and provided SQL server administration to client's database environments in support of various enterprise applications
Administered the implementation of database objects and structure changes to several environments and analyzed data with profiling, verification, lineage, migration, quality, and validation
Assumed responsibility in creating and troubleshooting log shipping and mirroring, including development and maintenance of replication
Maintained the clustered SQL server instances; managed security through logins, users, and roles, as well as formulated and used Source in targeting documents, business rules documents, and technical documentation and information flow charts
Collected and analyzed the clients' requirements by maintaining regular interaction to provide post-implementation support

Confidential, Nashville, TN

SQL Developer/Database Administrator

Responsibilities:

Developed a database maintenance planner to boost the performance of SQL Server and interface stored procedures to load data for scheduled jobs
Conducted performance tuning on various databases by fixing indexes, partitioning table, using temp tables, and redesigning schemas
Formulated databases and schema objects as well as analyzed and designed software and database solutions
Built SSIS packages involving ETL process; extracted data from various flat files, Excel files, and legacy systems, loading them into SQL server; as well as designed ETL packages dealing with different data sources
Took charge of generating dashboard pages in SharePoint Server using different types of web parts and Excel services for reports
Functioned as a developer, responsible for creating complex stored procedures, SSIS packages, triggers, cursors, tables, and views as well as other SQL joins and statements for applications
Used SSAS in developing multidimensional cubes; designing DW schemas; as well as in designing and building the dimensions and cubes with star schema
Completed the development of SSIS/DTS packages to copy tables, schemas, and views as well as to extract data from Excel and Oracle
Performed extensive design of high-level ETL architecture for overall data transfer from source server to the enterprise services warehouse

Confidential, Detroit, MI

Database Administrator

Responsibilities:

Rendered direct engineering support and on-call support for SQL Server databases and servers through the use of SQL Server 2008R2 and 2012
Executed strategic planning and design of new SQL Server implementations, server-to-server migrations, and upgrades
Provided standardization and consistency within environments while ensuring stability by designing, implementing, and monitoring database functionality
Conducted regular monitoring of backup and restoration of jobs; refreshed test databases from production; deployed new applications; led datacenter migrations; handled report generations; and implemented partitioning logic on heavy tables
Carried out the installation and development of SQL Server 2008 R2 and 2012 instances as well as deployed various new features
Collaborated with Microsoft Premier field engineers in resolving performance issues as well as CPU and memory bugs
Completed the automation of backup and restoration process from one server to another through T-SQL and SQL Server Agent jobs and Linked Servers
Imported data from clients’ asset and purchase order systems into the database hosted by Hayes Software Systems by creating several integration tools with SSIS
Executed query tuning for the application through SQL Server query execution plan and Database Engine Tuning Advisor; updated the database schema and seed data for clients' databases; and formulated application files to clients’ and internal sites on IIS server for the software release

Confidential, Dearborn, MI

Database Administrator

Responsibilities:

Offered exceptional tier 3 level engineering support as well as on-call support to SQL server databases and servers using SQL Server 2008, 2008R2, and 2012
Enabled the deployment of various components as part of an end-to-end implementation of business intelligence solutions as wells as planned and designed new SQL Server implementations, server-to-server migrations, and upgrades
Installed the listener creation on production and pre-production standalone SQL servers and availability group creations in SQL Server 2012
Performed installation and development of SQL Server Denali instances and integrated several new features

Confidential, Schaumburg, IL

Database Administrator

Responsibilities:

Rendered software build support and ongoing assistance in performing build activities to guarantee on-time delivery of testing, pre-production, and production software builds within a highly software development life cycle process as well as developed cross-functional flow charts as part of reverse engineering
Took charge of collecting user requirements from users and managers to ensure better understanding of the business logic of the company while developing the database based on their needs
Assisted in generating logical database and physical database architecture for servers using normalization up to third normal form
Conducted installation of SQL servers 2005, 2008, and 2008R2; service packs; and hot fixes; as well as performed critical patching on various production, such as active and active-passive cluster boxes and standalone cluster instances
Implemented backup automation on all production servers and configured the SMTP Server in sending automatic mails to the respective people
Oversaw the full report cycle, including authorization, management, security, and generation of reports

Confidential, Desoto, TX

Database Administrator

Responsibilities:

Provided support to the application written in Oracle PL SQL and converted it into T-SQL packages
Generated data extraction ETL jobs through the use of SSIS and DTS as well as extracted and loaded data from Microsoft Access, Oracle, and Microsoft Excel into SQL server databases
Carried out diverse functions, such as performance tuning, cube partitioning, and dimension design
Utilized the OLEDB in transforming data from various data sources as well as formulated test cases, test plan, and test conditions for QA testing
Created query plans while ensuring the use of appropriate indexes for each query
Managed data transfers between various servers using BCP and DTS and implemented DTS packages in transferring data
Assisted the Quality Assurance Team in validating and extracting data as well as in optimizing SQL Query
Made decision regarding the locking strategy used for various batch programming structures transactions
Improved the queries and the performance of database servers by using performance monitor and SQL profiler

We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

Richardson, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship