SQL Database Administrator Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SQL DATABASE ADMINISTRATOR
Professional Summary
A self-starter, innovative, constructive, and result oriented professional, seeking opportunity to work as a SQL Server DBA that will offer an opportunity for utilization of technical knowledge and further growth. Over 6 years of experience that includes analysis, programming, support, installation, networking, and database administration. Proven abilities to direct and troubleshoot database administration and networkadministration as well.

Experienced [Job Title] committed to maintaining cutting edge technical skills and up-to-date industry knowledge. Veteran systems architect with expertise in coding, application design, defined architectures and successful project leadership. Recent college graduate with network administration knowledge, including back-up, security management, e-mail systems and applications support.
Skills
  • Java/C/C++
  • Expert in Java, PHP and Perl
  • Database design
  • Python and Ruby proficient
  • Microsoft MSCA/MCSE Certified
  • Excellent problem-solving abilities
  • Windows and Linux
  • Website and portal monitoring
  • Data privacy applications
  • Network maintenance
  • System upgrades
  • System backups
  • Data backup and retrieval
  • Product templates
  • Technical specifications creation
  • Network upgrades
  • CISCO router management
  • Remote access technology
  • PHP
  • W3C DOM methods
  • Excellent communication skills
  • Enterprise technologies
  • Coding and modularization
  • IP Forwarding proficient
  • J2EE architecture specialist
  • Excellent diagnostic skills
  • Refined system debugging skills
  • Adobe Flash expert
  • SEO coding and strategy
  • Website maintenance
System backupsData backup and retrievalProduct templatesTechnical specifications creationNetwork upgradesCISCO router managementRemote access technologyPHPW3C DOM methodsExcellent communication skillsEnterprise technologiesCoding and modularizationIP Forwarding proficientJ2EE architecture specialistExcellent diagnostic skillsRefined system debugging skillsAdobe Flash expertSEO coding and strategyWebsite maintenance
Work History
SQL Database Administrator 05/2010 to Current
Company NameCity, State
  • Established compatibility with third party software products by developing program for modification and integration.
  • Developed and implemented complex Internet and Intranet applications on multiple platforms.
  • Coordinated with systems partners to finalize designs and confirm requirements.
  • Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
  • Diagnosed and troubleshooted UNIX and Windows processing problems and applied solutions to increase company efficiency.
  • Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
  • Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Streamlined and enhanced the corporate accounting and operations system.
  • Built application platform foundation to support migration from client-server product lines to enterprise architectures and services.
  • Designed strategic plan for component development practices to support future projects.
  • Utilized a pipe and filter model to find bottlenecks and enable measurement of system resource usage and process behavior at boundary limits of all operations.
  • Developed data architecture design to enable analysts to perform targeted customer analysis.
  • Recommended architectural improvements, design solutions and integration solutions.
  • Provided methodologies for object-oriented software development and efficient database design.
  • Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
  • Managed firewall, network monitoring and server monitoring both on- and off-site.
  • Advocated for end-users to perform testing and problem analysis for server, desktop and IT infrastructure work.
SQL Database Administrator06/2006 to 05/2009
Company NameCity, State
  • Installed, Configured, and Managed SQL Server 2000 &2005 in development, test, and productionenvironment Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005 Installed and Configured Operating Systems, Windows Server (2000 & 2003) Installed and Configured SQL Server Reporting Services (SSRS) Configured and Maintained Replications (Transactional) Configured Log Shipping as Standby database from Production database Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment Migrated MS Access 2000/97 databases to MS SQL Server 2000, and 2005 Migrated MySQL 4.1.0 databases to SQL Server 2005 Applied SP (Service Pack) on SQL Server 2000, 2005 Applied Patch on Windows Server 2003 Enterprise Edition Expertise in database Performance tuning Writing T-SQL and Stored-Procedures Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints(Unique/Check), Views, Stored Procedures, Triggers Data Modeling, developing E-R Diagram using ERWin, VISIO, and SQL Server Data Diagram Backward & Forward Engineering with data modeling tools mentioned above Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL ServerDatabase using DTS, SSIS, and BCP Generated Report using SSRS (SQL Server Reporting Services) Generated Report in Excel, html, and text from database as well Strong knowledge and working experience in Database Backup, Restore and Point-in-Time Recovery Scheduled jobs to automate different database related activities including backup, monitoring databasehealth, disk space, backup verification Developed Different Maintenance Plans for database monitoring Monitor Server Activity, Error Log, space usage, and solving problem as needed.
SQL Database Administrator01/2005 to 01/2008
Company NameCity, State
  • Installed, Configured, and Managed SQL Server 2008,and 2005 in development, test, and productionenvironment Installed and Configured SQL Server 2008 for testing different features and stability Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005 Installed and Configured Operating Systems, Windows Server (2000 & 2003) Installed and Configured SQL Server Reporting Services (SSRS) Configured and Maintained Replications (Transactional) Configured Log Shipping as Standby database from Production database Upgraded databases from SQL Server 2000 to 2005 in testing and production environment Upgraded databases from SQL Server Upgraded MS Access 2000/97 databases into MS SQL Server 2000, 2005, and 2008 Migrated Oracle 10g databases to SQL Server 2008 Migrated MySQL 4.1.0 databases to SQL Server 2005 and 2008 Applied SP (Service Pack) on SQL Server 2000, 2005, 2008 Applied Patch on Windows Server 2003 Enterprise Edition Strong on database Performance tuning Writing T-SQL and Stored-Procedures Used DBCC to check database conditions and Rebuilding indexes as well Assisted Database Developers to optimize SQL queries and Stored Procedures Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints(Unique/Check), Views, Stored Procedures, Triggers Data Modeling, developing E-R Diagram using ERWin, Visio, and SQL Server Data Diagram Backward & Forward Engineering with data modeling tools mentioned above Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP Export & Import data from/to databases like Oracle, MySQL, and Access to/from SQL Server Generated Report using SSRS (SQL Server Reporting Services) Generated Report in Excel, html, and text as well Strong knowledge and working experience in Database Backup & Restore Experience with Point-in-Time Recovery Restored Database from backup Working experience and strong knowledge in disaster recovery Scheduled jobs to automate different database related activities including backup, monitoring databasehealth, disk space, backup verification Developed Different Maintenance Plans for database monitoring Monitor Server Activity, and solving problem as needed Monitor SQL Server Error Log, space usage.
SQL Database Administrator09/2004 to 05/2006
Company NameCity, State
  • Installed, Configured, and Managed SQL Server 2000 in development, test, and productionenvironment Upgraded databases from SQL Server 7.0 to 2000 indevelopment, testing, and production environment Implementing business rules in Database.
  • Setting up referential integrity to maintain data integrity.
  • Creating stored procedures, triggers and other databases level constraints.
  • Setting up user rights integrated with Windows NT security and AD Optimization and tuning by setting up appropriate indexes and regular datamaintenance.
  • Participating in database modeling and logical and physical design.
  • Participating in the application development process and code reviews of databaseobjects.
  • Creating database design and development standards.
  • Bench marked and run time improved production systems.
  • Uploading of periodic data from remote sites.
  • Documenting MS SQL Server database design, implementation and configuration.
  • Developing scheduled task scripts.
  • Installing and configuring MS SQL Server Service Packs applicable.
  • Participated in Database Designing.
  • Setting up MS SQL Server and database configuration parameters.
  • Configuring MS SQL Server Clients.
  • Developing and implementing DBA maintenance plan.
  • Daily monitoring of MS SQL Server activity, error logs, NT event logs, space usageand security.
  • Developing and testing a backup and disaster recovery Plan.
  • Configuring and auditing MS SQL Server security.
  • Managing database object permissions, user accounts and passwords.
  • Administering NT Security for MS SQL Server.
  • MS SQL Server performance monitoring and optimization.
  • Analysis of MS SQL Server long-term performance trends.
  • Creation of MS SQL Server database devices, databases and database objects.
  • Scheduling and managing jobs on MS SQL Server.
  • Monitoring jobs performance and impact on normal.
SQL Database Administrator09/2004 to 05/2006
Company NameCity, State
Education
Bachelor of Science: Computer Science2005sunshine- City, StateComputer Science
Certifications
  • Microsoft Certified Professional (MCP)
  • Certified Information System Security Professional
  • Novell Certified Linux Professional 10 (NCLP10)
  • CCNP Routing & Switching
  • CCSP Network Security
Skills
ASP.net, AD, application development, ASP, auditing, automate, Backup, Client/Server, Clustering, Hardware, Crystal Report, Clients, Data Modeling, DTS, databases, Database, database design, database design and development, database modeling, Designing, disaster recovery, ERWin, ETL, features, HTML, IIS, ISQL, JavaScript, Linux, Managing, Access, MS Access, MS Access 2000, Excel, Mail, 97, MS SQL Server (7.0, Visual Basic 5, Windows 9, Windows, Windows 2000, 2000, NT, Windows NT, NT 4.0, Windows NT4.0, WindowsXP, MS-DOS, MySQL, MySQL 4.1.0, Enterprise, Network, Novell 4.11, Operating Systems, Operating System, Optimization, Oracle, DBA, Oracle SQL, Programming, RAID, Reporting, SAN, Scheduling, scripts, Shipping, MS SQL Server, SQL Server, SQL, SQL Server 2000, SQL Server 7.0/2000, SQL Server 7.0, Sybase, tables, TCP/IP, T-SQL, Unique, UNIX, VISIO, Visual FoxPro 5, Web Server, Web Design, Windows 2000 professional
Additional Information
  • Baltimore, MD20737 US Citizen Active Clearance

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • sunshine

Job Titles Held:

  • SQL Database Administrator

Degrees

  • Bachelor of Science : Computer Science 2005

Similar Resumes