We provide IT Staff Augmentation Services!

Database Administrator Resume

Irving, TX

Summary:

  • Ten plus years of IT experience in SQL Server Administration, Development, Design, Working experience of MS SQL Servers in Production, QA, Development environments.
  • Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
  • Experience in Replication, Mirroring and Log Shipping.
  • Experience in Database Backup, Recovery procedures.
  • Installing SQL servers, applying patches, resolving errors.
  • Experience in Reporting tools like Microsoft Reporting services.
  • Flexible and versatile to adapt to any new environment and work on multiple projects.
  • Experience in creating Ad hoc reports and tuning of reports.
  • Excellent knowledge in RDBMS concepts and constructs.
  • Experience in creating Jobs, Alerts and SQL Mail Agent.
  • Experience in working with managing SQL scripts and changes that are going to production.
  • Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS).
  • Good understanding of capacity planning.
  • Extensive knowledge of Relational Database Management Systems.
  • Expertise in planning and implementing MS SQL server security and database permissions.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
  • Hands on experience in trouble shooting database issues.
  • Experience in writing and debugging stored procedures and triggers.
  • Creation of users, configuring permissions and assigning roles to users.
  • Experience in Deploying SSRS reports and SSIS.
  • Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
  • Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Technical Skills:

Operating Systems Windows 2012/2008/2003/2000 , Windows XP, Windows NT 4.0 Server/Workstation, Windows 98/95, Windows 2000 Advance Server.

Languages T-SQL, SQL Plus, VB Scripts and ASP.

RDBMS MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0 and 6.5, Oracle, MS-Access

Front End MS Visual Basic

Internet Technologies ASP, HTML

Version Control Tools Visual Source Safe

SQL Server Tools Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS

Work Experience:

Confidential

Database Administrator

Responsibilities:

  • Installation of SQL server 2008 and applying latest patches on SQL server.
  • Backups, Linked server, Log Shipping, Replication and Mirroring.
  • Deployed stored procedures, views, triggers and user-defined functions using T-SQL.
  • Migration of SQL servers using side by side and in place technology.
  • Used monitor all subscription jobs and sends email alerts to the reporting team.
  • Deployed and monitored SSIS Packages.
  • Tuned Stored Procedures and SQL Queries and created indexes on tables.
  • Created SQL Server jobs for SSIS packages and scheduled them and monitored them.
  • Worked on tickets as per priority.
  • nteraction with Client to resolve any errors encountered.
  • Getting the requirements from new application and implementing it.
  • Supported change request on weekends.
  • Worked with Application team to resolve any issues faced by them.
  • Attended calls to rectify priority issues with different types of teams in the calls.

Environment:
SQL Server 2012/2008/2005 ,SQL Server Reporting Services, SSIS, Windows Server 2003/2008/2012 , Windows 7/8, MS Office, Excel.

Confidential

Database Administrator

Responsibilities:

  • Installation of SQL server 2008 and applying latest patches on SQL server.
  • Backups, Linked server, Log Shipping, Replication and Mirroring.
  • Migration of SQL servers using side by side and in place technology.
  • Created Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
  • Optimized queries to get sale of Policies done by each agent with different permutation and combinations.
  • Creating, maintaining, Upgrading, Migration of SQL servers.
  • Deployed the SSIS packages on different servers.
  • Optimized Query Performance and Reliability.
  • Created new tables and databases, normalized and indexed all the tables.
  • Ø Written stored procedures for front end and helped the front end application developers with their queries.
  • Cleaned and corrected data.
  • Worked on DTS packages.
  • Sent reports to the clients.
  • Tuned Stored Procedures and SQL Queries and created some indexes on tables.
  • Resolved tickets as per priority.

Environment:

Windows 7,VSS, MS SQL Server 2000,2005,2008,T-SQL, MS Excel, MS Word, MS Access.

Confidential

Database Administrator

Responsibilities:

  • Creating, maintaining, Upgrading, Migration of SQL servers.
  • Backups, Linked server, Log Shipping, Replication.
  • nstallation of SQL server and apply latest patches.
  • Migration of SQL servers using side by side and in place technology.
  • Designed databases and tables.
  • Created proper indexes for some tables for better performance of the queries.
  • Created Visio diagrams for some data bases.
  • Exported data from flat files to SQL server using BCP and Export\Import tool.
  • Created Maintenance job for the server.
  • Wrote complex SQL queries for data retrieval.
  • Designed new data bases for Reporting purpose.
  • Created stored procedures, tables, triggers, and views for databases.
  • Maintained and Made changes to application in VB 6 and ASP files used for uploading data.
  • Documented the guidelines for SQL programming.
  • Created a report to notify the status of all report subscriptions.
  • Worked on PL\SQL writing queries

Environment:

Windows Server 2003,Oracle PL\SQL, MS SQL Server 2000\2005, VSS, T-SQL, MS Excel,, MS Word, VB 6.0 and ASP

Hire Now