- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Sql Server Database Administrator Resume Samples
No results found
0-5 years of experience
Database Administrator and Network Administrator (MCSE, MCT, MCDBA, CCA, CCI, N+).
- Managed over 50 Production SQL Servers for a Multinational Company with zero downtime and no loss of data during time of responsibility (SQL Server 7.0).
- Coordinated with software developers to write stored procedures, enable security, and to create and develop best practice databases.
- Facilitated designing a data warehouse with over 500 gigs of information for an early warning system to avoid another tire recall, saving the company $12M+ in lawsuits.
- Built and supported production servers on a 24/7 support on-call schedule.
- Executed duties as a network and server administrator across multinational production network.
0-5 years of experience
Managed team of 17 personnel in the development, sustainment, and information assurance for Oracle 9i databases, 8i databases, Oracle Human Resources Application version 10.7, and Microsoft SQL Server databases supporting the United States Air Force automated personnel system.
- Administered 80 production, development, and test databases running on UNIX and windows based servers ensuring a 99.9% uptime rate.
- Set, enforced, and tested multi-system database administration security control processes. Eliminated over 20 security vulnerabilities. Documented user access management processes and configured Oracle audit trail capabilities.
- Researched and implemented a database performance enhancement that increased performance by 20% and averted a planned expenditure of $1M for a faster disk array.
- Led 6 major Oracle database/HR software releases with 250 database/application enhancements. Managed 192 hrs of build activities and reduced database upgrade time from 6 to 3 days.
- Saved organization $6,000 annually by eliminating a redundant Serena PVCS Version Manager (PVCS VM) UNIX based software configuration version management tool.
0-5 years of experience
Monitored and supported over 1500 SQL Server 6.x, 7.x, and 2000 databases on over 75 servers in a production environment.
- Analyzed database, stored procedure, and TSQL queries for optimizations and recommended enhancements.
- Diagnosed and resolved data corruption, locking, security, and connectivity issues.
- Performed database archival and recovery.
- Responsible for tier two escalations involving RAID and internal bug tracking applications.
0-5 years of experience
Database administration, SQL Server installation, backup configuration and validation, recovery, refreshes, and troubleshooting for 40+ SQL 2000 and 2005 database servers hosting over 700 databases.
- Developed a service line for the organization’s SQL database servers providing backup, monitoring, installation, server migration, upgrade and de-commission processes. Created a standardized support model for all internal database servers for Phillips’ Medical Systems.
- Trained offshore resources in all aspects of SQL Server database administration practices for the Philips Healthcare organization.
- Provided quality production support through proactive monitoring, planning, error trapping and maintenance automation.
- Installed, configured and migrated over a dozen instances of SQL Server 2000 to SQL Server 2005, including a SQL cluster and several mirrored servers.
- Developed dynamic scripts to assist in database administration tasks.
- Implemented [company name]’s ISeC Security standards mandated by Philips’ management for over a dozen servers.
0-5 years of experience
Designed, implemented, tested, populated and administered the Susquehanna and West Virginia Land OLTP Databases which tracked the ownership of land, surface rights, mineral rights, units, wells and associated energy leases for use in energy development in North Eastern Pennsylvania and West Virginia.
- Created procedures, functions, sequences, constraints and triggers to maintain data integrity. Applied indexes and partitions to improve performance. Created views for monitoring and reporting.
- Designed source to target mapping strategy and performed ETL to populate databases from existing dispirit data sources (text, Excel, Access etc).
- Integrated the Land Databases with the existing Arc GIS system.
- Using Microsoft Visual Studio, developed and implemented a visual basic front end application used for data entry which replaced all previous methods for data storage within the company.
- Created, maintained and monitored logging and archiving system to track user activity allowing for the rollback of erroneous input.
- Reviewed execution plans to optimize query efficiency.
0-5 years of experience
Created a monitoring database, stored procedures and SQL agent jobs to capture index fragmentation, database usage, table usage, LUN usage and stats. This information is used by an automated process that sends out preventive maintenance alerts and index rebuilds.
- Successfully improved the performance on our application through index analysis, removing unused indexes and analyzing stored procedures, functions and SQL scripts. One of the stored procedure tuning efforts resulted in a 2 minute duration to a few milliseconds.
- Administered our 3 node SQL cluster. Performing daily, weekly and monthly DB maintenance.
- Provided DB architecture recommendations to improve the overall performance of the app.
0-5 years of experience
Provide 24×7 supports to 50+ clustered SQL Servers both x86/x64 and on all versions of SQL Server.
- Installed, upgraded, and configured SQL Server multi instance clusters on SQL Server 2008 R2.
- Provided project management plan and support for ownership migration of 289 servers from IBM to Realogy Corp.
- Diagnosed and solved several performance issues using several different native tools.
- Acted as a system administrator as needed.
- Audited and reported all security threats and weakness
- Provided trend reporting.
- Mentored several DBAs in job functions.
0-5 years of experience
Managed MS SQL Server 6.5 database containing company user base and knowledge base.
- Controlled user authorizations.
- Performed data migration and mining using SQL queries, MS Access and MS Query.
- Established and executed data backup and integrity checks.
- Provided technical support to key Fortune 500 customers for Quadralays’ Web Works Publisher product, a tool used to convert Adobe Frame Maker documents to HTML, Win Help, HTML Help and Java Help formats.
- Used Frame Maker, HTML, Win Help and Java Help tags on a daily basis.
- Performed quality assurance testing on multiple platforms including Windows 95, NT Server, Macintosh and most flavors of UNIX (HP-UX, Solaris, AIX.)
0-5 years of experience
MS SQL Server 2000, Windows 2000, MS Visual SourceSafe and Embarcadero ER/Studio and Database Compare products
- Performed as a DPS Consultant to DPS client
- Planned, developed and supported several 5-20GB intraweb-based application databases in a SQL Server 2000/Windows 2000 environment
- Assisted in the design of new databases using Embarcadero ER/Studio
- Supported database environment using SQL Server 2000 tools and Embarcadero Change Manager
- Determined and implemented performance tuning measures
- Developed SQL replication creation and deletion scripts
- Implemented various Data Transformation Services (DTS) packages
- Maintained database environment security for development, test and pre-production environments
0-5 years of experience
- Coordinated database team and development team to migrate databases to a new data center. Upgraded SQL Server to SQL Server 2008 R2 in support of the decommission of obsoleted SQL Server and OS versions and converted DTS packages to SSIS packages
- Centralized firm-wide data tables and views to avoid unnecessary data sync processes and to ensure data integrity
- Successfully implemented performance tuning on developer’s SQL query to reduce the run time from 14 minues to 1 second
- Introduced and applied schema concept to simplify database maintenance and to improve security management
- Participated in the vendor selection process as the lead DBA to create Intellectual Property System for Chinese offices. Installed SQL Server 2012 Enterprise edition, configured Reporting Service and applied encryption. Assisted vendor in Britain to set up Sharepoint 2013
- Acted as the subject matter expert for DBA team in cross department effort for Kronos time building system upgrade while working closely with vendor, Project Manager and senior management including Chief Security Officer, Controller and Payroll Manager
- Set up Disaster Recovery process on Blackberry databases
- Troubleshot and fixed disk space, user permission and SQL job issues
0-5 years of experience
Worked extensively with clients in a variety of industries including: Non-profit, legal, medical, and education.
- Lead a team of developers responsible for ad-hoc reporting and CRM system customizations
- Managed SQL Server versions 2005 through 2014 in production, development and test environment
- Created lessons and trained clients and colleagues in SQL Server
- Regularly performed SQL Server service pack and Windows Service pack upgrades
- Analyzed execution plans to optimize query performance
- Developed backup plans based on client RTO and RPO
- Created and Maintained Virtualized SQL Servers
- Setup custom re-indexing maintenance plans to improve database performance
0-5 years of experience
- Installation and configuration of the SQL Servers and Databases.
- Backup and recovery -developed, implemented and periodically tested a robust and secure database backup strategy, where data lose and downtime were kept to a minimum.
- Database Design – Designed and developed databases for in house applications. Ensuring good design principles like normalization and referential integrity were followed.
- High availability – Designed and implemented database mirroring and log shipping to reduce downtime and improve availability.
- Storage and capacity planning – Monitored growth trends and recommended long term growth plans.
- Worked closely with senior management to design, develop and implement a reporting framework to provide a detailed snapshot of the key business areas. Using both Microsoft Reporting Services, Excel VBA and Crystal Reports.
0-5 years of experience
Performed Development DBA role in the area performance monitoring and tuning for the Microsoft side of FTI Consulting development project
- Provided SQL Server Administration to client’s database environments supporting multiple enterprise applications
- Managed installation and configuration of instances of sql server in the test and development environment
- Designed and implemented database backup and recovery strategies
- Managed deployment of database objects and structure changes to various environments
- Provided Support to ETL/BI specialists and application developers
- Conducted Data Analysis with data profiling, data verification, data lineage, data migration, data quality, and data validation
- Developed and utilized Source to target documents, business rules documents, technical documentation and information flow charts
0-5 years of experience
- Improve performance of SQL 2005 databases, ranging from 5-57 GB in size, spread across several clustered servers.
- Used T-SQL to gather statistics/metrics on current performance of databases and queries.
- Worked on indexes with a view toward creation, dropping and modifications to improve query performance
- Reviewed the server, database and code configurations to make sure each was optimized for the current load/usage type.
- Revised tables that were not normalized so that additional tables were created and all the resulting tables were normalized optimally.
0-5 years of experience
Maintained mission critical SQL servers, led SQL server side of projects, and worked closely with developers to troubleshoot and optimize development.
- Installed and configured MS SQL server in stand-alone/cluster environments.
- Saved revenues and image by fixing problem in SQL server, enabling completion of online transactions.
- Completed projects on time, decreasing costs. Improved processes and policies to maintain and support SQL server, enabling clean audits by public auditors.
- Supported over 150 instances of SQL servers in development, test, and production environments, including instances of 32/64 bit SQL servers, single/multiple clusters, and SQL 2005.
- Led projects from database standpoint, including suggesting data design to data architectural team, reviewing database recovery, and examining data code from performance perspective.
- Implemented test and production environments after project finalization.
- Provided ongoing support, troubleshooting system performance by reviewing OS performance counters as well as SQL profiler and PSSDIAG.
- Managed Oracle issues in development, test, and production by installing, configuring, and performing tuning.
- Led and managed the SQL team. Mentored the team whenever they needed technical assistance. Distributed the project load to team members.
0-5 years of experience
Performed all database administration task such as backup/recovery, and health checks
- Monitored growth, installation, and version compliance
- Performed installs of Microsoft SQL server and security patches to ensure integrity
- Maintain database standards and security.
- Redesigned the database backup infrastructure
- Upgraded all SQL Server 7.0 databases to SQL Server 2000 for version compliance
- Upgraded Peoplesoft Financials and HR applications from 8.45 to 8.8.
0-5 years of experience
Administer and Maintain SQL Server 2000 cluster servers. Monitoring and maintaining log shipping between SQL Server 2000 production clusters and Continuity of Business (COB) clusters.
- Work with developers for code creations, optimization of Stored Procedures and enforce coding standards. Work with Quality Assurance team to stress test and check for performance of code. Work with Data Center to successfully promote code to Production.
- Responsible for 10 SQL SERVER 2000 servers on windows 2000 platform and total of 30 databases.
- Administered and Maintained SQL Server 6.5, SQL Server 7.0, Paradox 4.0, Microsoft Access 97, and FoxPro databases. Also, monitoring and maintaining batch replication from SQL Server 6.5 to SQL Server 2000 database to generate Crystal reports.
- Creating disaster recovery strategies, database backup and restore methodologies, manage Security and database performance tuning.
- Scheduling batch jobs, monitoring alerts and error logs, and creating Data Transfer Service packages.
- Provide 24×7 support for production servers.
0-5 years of experience
Managed web based server applications hosted on Server via Internet Information Services (IIS).
- Instructed classes focused on teaching various Army and civilian Database administration.
- Proficient in implementing and managing Microsoft SQL Server 2000 and SP4 on an enterprise level.
- Provided upper level Database support for military units fielded with ULLSA-(E) program using SQL Server 2000/SP4.
- Implemented full unit specific Database maintenance plans including Backups and Data Transfer packages via SQL query analyzer.
0-5 years of experience
Administered SQL Server 2008 R2 Enterprise and Datacenter Editions.
- Designed and configured replication for Data Warehouse project.
- Troubleshot slow performance issues for mission-critical databases.
- Installed SQL Server failover clustering.
- Created testing environments and performed validation testing for developers.
- Created SQL Server Integration Services (SSIS) packages.
- Installed and configured SQL Server Reporting Services (SSRS).
0-5 years of experience
Administered SQL Server 2008 R2 Enterprise and Datacenter Editions.
- Designed and configured replication for Data Warehouse project.
- Troubleshot slow performance issues for mission-critical databases.
- Installed SQL Server failover clustering.
- Created testing environments and performed validation testing for developers.
- Created SQL Server Integration Services (SSIS) packages.
- Installed and configured SQL Server Reporting Services (SSRS).
0-5 years of experience
Migrated Patents, Trademarks and Disclosures from an acquisition of another company into the existing IP Master Intellectual Property Management Application (Thomson-Reuters). Led effort to migrate the system from the existing IP Master version to the new IP Manager web-based version of the system.
- Worked closely with the PMO to coordinate and assist with all aspects of managing the effort.
- Figured out how to access and extract data from the 4D database holding the existing data.
- Led discovery process to map data from the external company into the existing system.
- Wrote all data conversion programs and facilitated during the Q/A testing cycles and regression testing.
- Supported the effort to upgrade the system to the new IP Manager release.
- Systems were running on SQL Server 2005 and SQL Server 2008 R2.
- Data migration extracted from 4D database.
0-5 years of experience
Served as a member of a team of SQL Server database administrators responsible for over 100 database server workloads supporting Department of Defense customers worldwide. Worked on both classified and unclassified workloads. Held a top secret clearance and CompTIA Security+ certification.
- Supported several critical Department of Defense SQL Server database system workloads
- Led an effort to update several database servers from SQL Server 2005 to 2008 R2 while migrating user databases to new hardware
- Provided daily maintenance support to all assigned database system workloads
- Worked closely with system administrators to troubleshoot Windows system problems on database servers
- Installed database management system service packs and upgrades
- Performed security manager functions for all assigned database system workloads
- Ensured all databases met stringent DOD security requirements by performing security hardening procedures on each database
- Participated in weekly teleconferences with customers to discuss and plan upgrades to their workloads
- Monitored storage space utilization and made recommendations for improvements
- Provided after hours on-call support and responded to all help desk calls
0-5 years of experience
- Served as MS SQL Server Database Administrator. Implemented and supported web based N-tier application for our clients. Provided backup solution for hosted web services. Also provided the consulting service for our clients
- Performed System Management Server 1.2 upgrade to System Management Server 2.0 + SP3 for Newark
- OnStar Web Hosting Project. Installed and configured the Win 2k advanced cluster server, SQL 2000 cluster
- 1StInHealth.com Project. Served as SQL Server DBA, responsible for database design, performance tuning,
- Magic Total Service Desk System. Served as consultant to implement and support web based help desk
0-5 years of experience
Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Migrated SQL server 2000, 2005 to SQL Server 2008 in Microsoft Windows Server 2008 Enterprise Edition
- Provided greater visibility into risk profiles by generating senior management infrastructure change metrics, reports and dashboards using ITSM6 data.
- Migrated multiple mission critical applications such as Sharepoint, Good, Blackberry to the latest infrastructure. Worked with customers on Application rollouts and server migrations
- Recovered the databases from backup in disasters. Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Worked on remediating audit point violations.
- Good experience with SQL Server Clustering and monitoring of database size and disk space in Production, Staging & Development environments
- Worked with the 2011 TA class to develop and implement a recruiting mobile application for the iOS platform.
- Responsible for the development and testing of the two key modules.
- Coordinated data exchange with the Business Analysts.
0-5 years of experience
Providing SQL Server Administration to client’s database environments supporting multiple enterprise applications
- Designed database backup and recovery strategies
- Create and enhance schema
- Managing deployment of database objects and structure changes to various environments
- Support ETL/BI specialists and application developers
- Conducted Data Analysis with data profiling, data verification, data lineage, data migration, data quality, and data validation.
- Participated in the ETL job design and testing in data warehouse
- Created and utilized Source to target documents, business rules documents, and technical documentation and information flow charts.
0-5 years of experience
Upgraded SQL Server 2000 databases to SQL Server 2005
- Performed all database tasks such as disaster recovery, performance tuning, and partitioning
- Monitored growth, installation, and version compliance
- Administered and maintain database policies for security and data integrity
- Provided capacity plan, configuration, and hardware requirements for physical databases
- Provided proactive monitoring of databases and database objects for optimal performance
- Implemented database solutions using SAN storage technology
- Proactively monitored, troubleshoot, and correct all database issues to optimize performance
0-5 years of experience
As the primary SQL Server Database Administrator I was responsible for all SQL Server Instances for all SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 as well as SQL Server 2012
- Implemented standard database backups, transaction log backups and maintenance plans
- Implemented standard security in development, test and production environments
- Developed consistent standards and procedures for servers being brought under the Database Services team
- Provide various IT teams and business users with SQL Server support and guidance
- Install SQL Server instances based on user requirements. Also install Reporting Services, Analysis Services and Integration Services
0-5 years of experience
Lead the DBA team Responsible for design, plan and implementation of all Sybase servers.
- Install, upgrade, configure, maintenance, troubleshoot and performance tuning of Sybase, Replication servers across production, UAT and development environments.
- Design, implementation of Sybase-Sybase replication.
- IQ Servers Setup, Migration of IQ Servers and Maintaining IQ Servers.
- Managed and Lead Linux and ASE15 Migration projects.
- Developed the process documents for all DBA maintenance task for Sybase and Replication.