- Featured in:
-
More Ms Sql Server Dba Resumes
Use these Ms Sql Server Dba samples as a guideline or visit our extensive library of customizable good resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Ms Sql Server Dba Resume Samples
No results found
0-5 years of experience
Maintained over 55 SQL Server machines; over 100 instances; over 700 databases in this organization’s global environments.
- Designed, building, installing, configuring and supporting Database servers.
- Applied the following concepts and features: Database Management, MS SQL Server 6.5 though SQL Server 2005, SQL Programming, Database Security, Requirements Analysis, Data Maintenance, Database Performance Tuning, Large Clustered System Implementation.
- Installed, maintained and patched the MS-SQL software; created, moved, upgraded, and deleted databases; implemented backup and recovery processes; performed routine maintenance on databases; monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views; implemented and maintained security rules and security audits; maintained state of audit readiness; problem resolution.
- Deployed and maintained a SQL clustering environment.
- Monitored database system details within the database, including stored procedures and execution time.
- Monitored, optimize and requested allocation physical data storage for database systems
- Planned and coordinated data migration between systems.
0-5 years of experience
[company name] is a Banking giant Based in Canada; it is a 24*7 basis support project for all locations across the Globe. With SQL Server as its database backend, I was responsible for administering the database servers.
- This application will helps client in developing websites and managing information about users who are using this site by different browsers, different areas, different port addresses etc.
- Provided Security, consistency, efficiency, track state etc.
- Involved in analysis, design, coding, unit testing, integration testing, system testing.
- Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems.
- Involved in analysis, database designing, coding and testing.
- Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
- Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
0-5 years of experience
Manage projects including disaster recovery plan, RPO, and RTO. Optimized prevention and recovery strategies and data flow on a network of SQL servers which contained 95% simple recovery model.
- Consistently monitor all parameters on SQL for 9 instances via Spotlight (Sessions, processes, [esp. evaluating blocked/locked/deadlocked threads), memory, and storage.
- Constructed SSIS packages, tested and implemented to import-export OLEDB sources.
- Coordinate SSRS, SSIS packages, maintenance plans, stored procedures, transactional/merge replication and latency
- Evaluate and monitor execution plans, query plans, key lookup operators for all troubled code; Evaluate transaction isolation levels.
- Analyze clustered/non-clustered index allocation and included columns, and optimization of query plans.
0-5 years of experience
[company name] is a leading global provider of best-in-class Clinical, Commercial, and Consulting services for companies seeking to accelerate performance. inventive Health’s clients include more than 550 pharmaceutical, biotech, and life sciences companies.
- Specifically hired for SQL Server migration project. To migrate Production and non-production servers from SQL Server 2000, 2005 to SQL Server 2008 and SQL Server 2012.
- Installed and configured SQL 2008 and SQL 2012 on WINDOWS 2008 systems.
- Created the backup and restore strategy for production, development and test environments.
- Involved in Always On for High Availability and reporting purpose and created the documentation.
- Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.
0-5 years of experience
Senior Team Leader at the Federal Retirement Thrift Investment Board (FRTIB) heading up the support of the Death Benefit (DEDIS) and Court Order (CODIS) applications.
- Interface with the customer to gather requirements for System Change Requests (SCRs) submitted by users of the DEDIS and CODIS applications.
- Managed and reported on development, testing, and deployment of SCRs.
- Develop and test DEDIS and CODIS enhancements in Visual Basic.NET 2008.
- Develop SQL based solutions to handle requirements from developers in the SQL Server 2008 back-end databases.
- Maintain and tune production and development SQL Server 2008 databases through maintenance plans and backup procedures.
0-5 years of experience
- Designed new/more efficient power distribution system for 240+ servers
- Supported the U.S. Government department PERL code, and network and database infrastructure in a Public Trust environment.
- Provided MS SQL Server DBA support for all SQL Server databases.
- Designed new rack configuration to support virtualizing over 240 physical Microsoft servers into 40+ physical servers, using VMWare, resulting in significant cost savings for the client.
- Performed configuration analysis of current network topology to guide the virtualization of 240 physical servers into 40+ physical servers.
- Assisted in virtualization of the 240 physical servers using VMWare.
0-5 years of experience
- Worked in team with Business Analysts and Developers in identifying the requirements, designing and implementing database schema and application.
- Created new database and tables using scripts.
- Maintained User Databases and System Databases.
- Performed Tuning of Stored Procedures, SQL Queries and User Defined Functions
- Implemented Trigger to maintain data integrity and consistency.
- Planned and scheduled automated backups & performed recovery.
- Created user logins and add users to respective databases.
- Actively involved in hardware and network specification, installation and configuration.
0-5 years of experience
Key Deliverables – Database Administration, Disk Configuration, Tuning, Architectures
- Return engagement back at Federal Mogul to provide database support
- Assist setting up redundant UNIX and NT servers.
- Duties included disk configuration, tuning, documenting architecture, and reviewing developer code as it moves through development, test, and production environments
- Installed and configured Oracle, JRUN, Apache, WebSphere, IIS environments for a manufacturing distribution system called Optum’s Move.
- Implemented Disaster recovery by moving half the computers to South Field, Michigan and the other have to St. Louis. Work as a team member to find ways to handle network domains and backup/recovery procedures.
0-5 years of experience
Lead technical team(s) responsible for implementing peoplesoft environments and performing the peoplesoft upgrade of the CIS, hrms, supply chain, crm and campus solutions peoplesoft application environments.
- Setup and deployed EPIC Clinical applications with MS SQL Server database (Hospital, Billing, Scheduling, Ambulatory, Call Management).
- Deploy EPIC Clinical Application module; Performance tuning application database queries; Design and architecture adjustments per hospital application requirements; Implementation of new modules and database migrations to data warehouse.
- Setup/Clone/Install and Properly configure all development, test, and production environments with an application server, web server, process scheduler and oracle/MS SQL Server backend database for the peoplesoft (8.4 to 9.0) CIS, Supply Chain, CRM and Inventory (9.0) environments.
- Properly setup and configured the upgrade assistant to perform the appropriate tasks for compare reports between (8.4 to 9.0)peoplesoft repositories.
- Peopletools Upgrade from 8.45 – 8.49
- I setup the reporting environments for use with both SQR and Crystal Reports configurations with the application server and single sign-on.
- I setup and configured integration broker, application messaging and single sign-on via peopletools for the environments that needed them.
- Change assistant was used to complete the peoplesoft patching necessary to bring the CIS Solutions to the current patch levels recommended for the upgrade path.
0-5 years of experience
- Responsibilities included database design, creation, maintenance and administration for several MS SQL Server 2000, SQL 2005 and Sybase 12.x databases, Windows 2003 Clustering (Active/Active & Active/Passive)
- Maintained regular backups, restore databases and transaction logs as needed
- Responsibilities included recovery, import/export and replication of data, scheduling of tasks and monitoring their status
- Responsibilities included the creation, maintenance, and transfer of DTS packages; scheduling and maintenance of SQL jobs
- Utilized XML format and relational database to store and exchange data
- Migrate and upgrade SQL Server 2000 to SQL Server 2005
0-5 years of experience
Installing, configuring SQL Server & Migrating and Upgrading SQL Server databases.
- Database maintenance tasks (rebuilding and reorganizing indexes, updating statistics and running DBCC.)
- Scheduling Maintenance and other jobs, developing Database backup and Disaster recovery solutions.
- Setting up and monitoring high availability solution such as Replication, Mirroring, Log Shipping and Failover Clustering.
- Develop, Implement and Administer policies and procedures for ensuring the security and integrity of database.
- ETL and SQL Server Integration services (SSIS), creating reports in SSRS
- Proactive Monitoring of SQL Server using DMV’S, SQL Profiler, Activity monitor, Performance monitor and Event Viewer and Spotlight.
- Creating database objects (indexes, stored procedures, tables, triggers and constraints.)
- Defragmentation of indexes (reorganizing and rebuilding.)
- Participating in database development and production testing.
0-5 years of experience
- Development/Modifications of Store Procedures, Transactions, Creating DB schemas based on BRD, Troubleshooting and fix production problems (data and system related), prepare test plans for SQL projects, train and consult developers on functions and procedures creation (code review, promotion to QA and/or production), optimization, performance monitoring, index tuning. Convert MS Access applications to SQL/Oracle. Help with XML extracts. Set Full Text Catalog and maintenance. Use PL/SQL; t-SQL.
- Data analysis and cleansing, data transfer and operations, create reports and processes for reports, help with Crystal reports, CorVu, and create OLAP reports including data warehouse creation and maintenance, training with cube operations and pivot table use. Prepare data for application switch (SQL/Oracle), Transfer from Progress database to SQL. Help in QA processes. Crete data models per project requirements (Use ERWin). Work on Data repository/Data warehouse. Set and maintain linked servers, ODBC. Performing Data Transfer between Progress and SQL/Oracle
- DB Maintenance, installation (Cluster/no cluster), apply patches; create/monitor jobs, performance, space management, backup/restore, data connectivity, OLAP settings. Maintenance plans, jobs and DTS packages creating, manipulating. Use SpotLight to monitor and tune servers. 24/7 support
- Participate in research of ETL/BI tools.
Data Systems Administration Cover Letter Examples
Rate This Article
Ms Sql Server Dba
Last edited by: Gabriela Barcenas, CONTENT STRATEGIST -
Gabriela Barcenas
CONTENT STRATEGISTGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
