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