Sr Sql Server Dba Resume
2.00/5 (Submit Your Rating)
WashingtoN
SUMMARY
- 6 years of experience as SQL Server Database Administrator and enterprise information technology operations
- 5 years of experience as SQL Developer
- Experience working in hybrid environment, deploying and managing SQL Server databases
- Experience in planning and configuring windows server failover cluster, designing and implementing high availability/disaster recovery applications using various SQL Server features including Always On availability groups
- Installed and configured multiple virtual machines on Azure and Managing about 200 SQL server databases, Performed Migration of SQL server instances and databases in hybrid environment
- Experience in Windows Server Infrastructure, SQL Server installation, administration and production support
- Experience in server configuration, upgrades, patches, space management, database security, database design, management plan configuration, database scripting and documentation.
- Experience in installing, maintaining, configuring and tuning SQL Server on Windows and Linux server environments
- Experience in security management, process management, backup and restore management. Performance monitoring, turning and optimization.
- Experience in designing, configuring and managing databases using either T - SQL or power shell
- Flexible, team player, “get-it-done” personality.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
- Ability to multi-task and context-switch effectively between different activities and Teams
- Ability to Provide 24x7 support for critical production systems.
- Ability to assist developers with complex query tuning and schema refinement.
- Ability to research and has issues resolved faster
PROFESSIONAL EXPERIENCE
Sr SQL SERVER DBA
Confidential, WASHINGTON
Responsibilities:
- Created views on a table or selected tables for specific purposes, in order to simplify database schema complexity to a none IT person, particularly for application users
- Created triggers and store procedures for security and process management
- Designed and implemented automatic Backup and Restore Strategies
- Performed Performance Bottleneck Analysis using SQL Profiler, DTA, Query Execution Plans,
- Tuned SQL Server performance in virtual environments (VMWare) with various SANs
- Proactively monitoring databases to ensure high performance and high availability
- Created after or instead of triggers to monitor any insert, delete and update on certain tables in addition to logon triggers on the server to monitor login security or activities
- Worked on various DBA tasks including patching, cloning and upgrades
- Performed database security management on both database and network levels
- Performed installation SQL server and configuration of SQL Server database objects
- Extensive experience in installing and implementing SQL Server Management and data tools
- Hands on experience in the configuration of single instance and multi node SQL Server Infrastructure
- Recommend solutions by defining database physical structure and functional capabilities, database security, database back-up, and recovery specifications
- Maintain database performance by evaluating the size of databases, server operating systems and hardware products
- Identify database requirements by interviewing customers, analyzing applications, programming, and operations. Evaluating existing systems and designing proposed systems requirements
- Maintain professional and technical noledge by attending educational workshops, reviewing professional publications, establishing personal networks
- Contributing to team effort by accomplishing related results as needed.
- Deploying databases at every stage of deployment, ranging from development, testing, staging and production environment, Also Carried out version control process
- Administer databases in both development and production environment
- Transforms and loads data into database using SQL Loader or ETL process in SSIS
- Supports the development team on application development and deployment
- Work on physical data modeling and updates physical data models based on logical model changes
- Perform in place and side by side migration of databases from SQL server 2008 to 2016
Jr SQL SERVER DBA
Confidential Arlington VA
Responsibilities:
- Worked with team to ensure appropriate hardware resources are allocated and work with users to develop and optimize their SQL Server queries
- Designed and perform various disaster recovery procedures and database maintenance
- Created documentation and training plans for staff and end-users
- Performed various standard DBA tasks. create, update, drop and delete databases and database objects, when necessary
- Participated in the design and development of ETL Jobs using SQL Server Integration Services (SSIS) for data migration between different maintenance systems
- Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems
- Assists the technical solutions team with testing and implementing technical enhancements to the site, tools for task tracking, version control, and other operational support areas.
- Provisioning permission to users and developers on specific database as needed
- Served as liaison with outside IT offices regarding database matters.
- Worked with other DBAs to implement physical data models in database.
- Synchronizes physical data model and database implementation
- Designed complex SSAS solutions using multiple dimension perspectives, hierarchies. Measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers