sql server developer dba resume example with 7+ years of experience
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA94105
:
Summary
Jessica Claire
Certified SQL DBA/Developer Over 5+ years of experience in Database Administration using MS SQL Server 2008/2012/2014.
Has 1+ years of experience in using Elastic Search and Altreyx
Has Ā experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments; with 2+ years of experience as a SQL Server DBA/ETL developer.
Very good experience in Installation, configuration and maintenance of SQL Server.Ā
Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
Ā Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
Experience in Database backup and disaster recovery procedures.
Experience in Replication ā Snapshot, Merge and Transactional.
Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
Worked in OLTP & OLAP environment that includes Production (24x7).
Extensively worked on Active-Active and
Active-PassiveĀ Clustering.Ā
Ā Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
*
Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
Migration experience with multiple databases/servers from SQL 2008R2
and SQL 2012 to SQL 2014.
MonitoringĀ SQLĀ server Error
logs, Disk Space growth,Ā ClusteringĀ Environment.Ā
Monitoring
Indexes for Performance Related
Issues .
Experience and Knowledge on HA/DR like
log shipping/Mirroring/Clustering&
Replication.
Extensive experience in implementingĀ ClusteringĀ and
mirroring on physical and virtual machines.
Experience in Creating Roles and managing
user permissions, Jobs, Alerts, SQL Mail Agent, and using performance
monitor/profiler for resolving deadlocks.
Education and Training
Marist CollegePoughkeepsie, NYExpected in 2016 ā āMaster of Science:Information Systems - GPA:Information Systems 3.4
Jawaharlal Nehru UniversityHyderabad, Expected in 2011 ā āBachelors of Technology:Computer Science - GPA:Computer Science 3.5
Certifications
Microsoft Certified Professional (MCP)
MCSA: SQL Server 2012/2014
ITIL V3 Foundation certified
Oracle certified Java Programmer(OCJP)
Salesforce Certified Cloud Developer
Accomplishments
Designed and implemented Elascticsearch for the client.
Created Data indexes using ElasticSearch(NoSQL) for fast accessing data
Implemented Altryx to create packages
Upgraded over 20 SQL servers to the latest version in a 3-month period.
Improved vital processing jobs by reducing process duration by 60%.
Enrolled users, maintained system security, and controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time.
Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime.
Employee of the year 2013 in Cognizant Technology Solutions
ā
Experience
Iron Mountain - SQL Server Developer/DBA Denver, CO, 06/2016 - Current
Provides ongoing support for MSĀ SQLĀ SERVER database servers for systems, which include creation, configuration, maintenance and upgrade.Ā
Installed and Configured MSĀ SQLĀ SERVER on Stand-Alone, and Failover Cluster.Ā
Designed and implementedĀ SQLĀ server's migrations from 2008R2 to 2012/14/16.Ā
Configured and Managed the High Availability and Disaster recovery Solutions Always On, Replication, Clustering on Critical Production Servers.Ā
Configured and Managed Always On Availability Mirror Groups and Replica Databases.Ā
Upgrading the existing servers with Service Packs, Patches and Hotfixes.
Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.Ā
Perform database troubleshooting, management, backup, restore and routine maintenance DBCC, Re-index of database table indexes, database performance tuning.Ā
Managed Users, Roles, Principals and Securable Administration to access the databases at various levels to provide better security on bothĀ SQLĀ Server and Windows Authentication Modes.Ā
Monitored database status including CPU, memory, I/O, space, and dead lock usingĀ SQLĀ Server Utilities.Ā
Developed SSIS and SSAS packages inĀ SQLĀ Server using Business Intelligence Studio and created jobs to schedule the SSIS and SSAS packages inĀ SQLĀ Scheduler.
Migrated SSIS and SSAS packages from development to test to Production environments using SSIS configuration files and deployment wizard.Ā
Cognizant Technologies For MANULIFE FINANCIAL - SQL SERVER DBA City, STATE, CANADA01/2013 - 05/2014
Worked with Terabytes of Data with over 500 databases.
Installed recommended service packs and security patches on production, test and development servers.
In SQL 2008R2 set up Database Partitioning to improve query performance.
Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
Utilized Resource Governor to handle two applications on the Server.
Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers.
Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best Practice Analyzer.
Experience in Shell scripting (Perl, power shell).
Expertise in Using Third party tools like DB artisan, Commvault.
Monitoring and Troubleshooting jobs, Backups and Restore database policies.
Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
Thorough understanding of standard SOP's, SLA's and change control management process.
Generating Reports as per the requirement using SSRS 2005/2008.
Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
Environment: SQL Server 2008/2012, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL, UNIX, AIX servers.
Cognizant Technology Solutions - SQL Server DBA/Developer City, STATE, 2012 - 01/2013
Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS (ETL).
Responsible for Installations and configurations of SQL Server 2008, applying Service packs.
Installed and Configured SQL Server 2008 and Clustering Services.
Worked on SSIS packages using SQL Server 2008.
Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e.
Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
Implemented high availability solutions, including Clustering, Database Mirroring, Replication and Log Shipping.
Worked extensively on Data Modeling on creation of new data models add existing tables to the data models and creation of new tables.
Used Replication (both Transactional and Merge replication) to move databases from SQL server 2000 to SQL server 2005.
Extensively worked on SharePoint projects and applications having Terra bytes of databases.
Good knowledge and experience in TEAM FOUNDATION SERVER(TFS).
Experienced in Configuring, Implementing and Maintaining Database Mirroring.
Extensive experience in Configuration, Implementation and Maintenance Using Log Shipping, Transactional and Merge Replication in SQL Server2000/2005.
Performance Tuning to increase the speed and performance of website, tuning hardware and software requirements.
In SQL 2008R2 set up Database Partitioning to improve query performance.
Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
Environment: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5, T-SQL, SSIS, and SSRS, ETL.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.