We provide IT Staff Augmentation Services!

Sql Database Administrator Resume Profile

5.00/5 (Submit Your Rating)

OBJECTIVE

To find a challenging position that will utilize my skills and knowledge to their fullest, while providing me with ample opportunity to learn, grow and advance in the information technology field.

PROFESSIONAL EXPERIENCE

Confidential

SQL Database Administrator/Developer

  • Build and maintain an enterprise database environment
  • Administer an enterprise level environment with Microsoft SQL Server 2000, 2005, 2008 R2, 2012 and 2014
  • Configure and manage security, maintenance, backup plans, high availability and disaster recovery of hundreds of databases across the enterprise
  • Setup and mainain database mirroring and replication across multiple servers
  • Participate in an on-call rotation to resolve any issues that may arise
  • Develop new stored procedures, SSIS packages and SSRS reports to meet business needs
  • Implement changes to test and production environments by deploying code, packages and reports while adhering to a strict change control process
  • Manage database performance through tuning and optimization of SQL queries and server and database settings to ensure smooth and optimal performance and functionality
  • Assist in creating and implementing new enterprise standards for database and server configurations as well as training of new employees

Confidential

SQL Database Administrator

  • Administer an enterprise database environment across hundreds of SQL servers and thousands of databases
  • Plan, build and configure 2 and 4-node clustered server environments with Microsoft SQL Server 2000, 2005, 2008 R2 and 2012
  • Configure and manage security, maintenance, backup plans, high availability and disaster recovery of thousands of databases across the enterprise
  • Setup and manage database mirroring, replication and availability groups across several remote datacenters
  • Participate in an on-call rotation to resolve any issues that may arise
  • Resolve change requests to deploy SSIS packages, SSRS reports, access requests, and various database changes in a high-paced and multitasking environment
  • Manage database performance through tuning and optimization of SQL queries and server and database settings to ensure smooth and optimal performance and functionality
  • Assist in creating and implementing new enterprise standards for database and server configurations as well as training of new employees

Confidential

  • Test the functionality of changes to SQL Server and Oracle databases.
  • Create test plans, test cases and reports for testing database changes in a timely manner
  • Write T-SQL and PL/SQL queries for testing or data retrieval edit and schedule DTS packages and jobs
  • Troubleshoot database issues across several SQL and Oracle QA environments
  • Collaborate with teammates, developers and database administrators on meeting deadlines
  • Communicate clearly and professionally with all colleagues

Confidential

Software Developer

  • Customize Microsoft Dynamics CRM and create complex reports using SQL Server 2005 and SSRS Reports in Visual Studio 2005.
  • Install, customize and troubleshoot Microsoft CRM for several clients
  • Write complex T-SQL queries using SQL Server Management Studio 2005
  • Transform client requests into robust reports using Microsoft SQL Server Reporting Services SSRS
  • Create backups of company databases and restore them on new development servers
  • Manage, configure database replication and optimize client and company databases
  • Utilize Scribe to create custom DTS packages for bulk data transfer to and from Microsoft CRM databases
  • Troubleshoot custom callouts in Microsoft CRM and assist in the creation of new ones using C
  • Work with one of the nation's largest online schools to implement a Microsoft CRM installation communicate with them on a daily basis and implement changes and additions to their CRM
  • Train new employees and assist in their knowledge and understanding of SSRS, SQL Server 2005 and customization of Microsoft CRM
  • Research, plan and execute the upgrade of Microsoft CRM 3.0 to 4.0
  • Create custom web pages using ASP.Net
  • Create and implement custom Javascript code to format various data fields

Confidential

eDiscovery Database Technician

  • Create, edit and manage company databases for processing legal documents.
  • Act as a database administrator for hundreds of company databases using Microsoft Access and MySQL
  • Work on multiple projects simultaneously under strict time constraints in a team environment
  • Design custom SQL queries for managing data in databases
  • Use company software to access files in the database, format them, extract text and convert them to an image format
  • Utilize various software packages to format, compress and transfer files to designated FTP or server locations
  • Perform extensive quality control on all formatted files with great attention to detail

We'd love your feedback!