SUMMARY:

• Highly motivated SQL Server DBA with experience using SQL Server Management Studio and working with Amazon Cloud Services.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS:

Programming Languages: Transact SQL, basic C# and VB

SQL Versions: Microsoft SQL Server 2005, 2008R2, 2012, 2014

Operating Systems: Windows Server 2003, 2008 R2, Window 2012 R2

Software: Microsoft SharePoint, Red Gate SQL Backup, SCOM, SSRS, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, FL

Lead SQL Database Administrator/AWS Engineer (contract)

• 9+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server in Production, Test, Development and Cluster Server/HADR Environments
• Implement and troubleshoot Microsoft SQL Server 2008R2 - SQL Server 2016, Microsoft Azure Database and AWS database services.
• Lead a team of four DBAs to ensure we deliver proactive solutions
• Lead the efforts in changing our HADR solution from SQL Clustering with Mirroring to a Multi subnet Always ON solution.
• Troubleshoot and Performance Tune SQL Server with PSSDIAG/PAL/Idera/Xevents/DMVs and now Query Store.
• Tested and worked on Distributed Availability Group SQL in 2016
• Experience in Infrastructure Development and Operations, involved in designing and deploying utilizing AWS stack like EC2, EBS, S3, VPC, RDS, SES, ELB, Auto scaling, Cloud Front, Cloud Formation, Elastic Cache, Cloud Watch, SNS, Route 53.
• Using Ansible as an automation tool for deploying of Instances on AWS environment, deploying of VPCs, S3 buckets
• Creating AMIs and volume snapshots as backup for instances
• Implemented AWS high-availability using AWS Elastic Load Balancing (ELB), which performed balance across instances in multiple availability zones.

Confidential, MD

SQL Premier Field Engineer

• Implement and troubleshoot Microsoft SQL Server 2008R2, SQL Server 2012, SQL Server 2014 or Microsoft Azure Database, SQL PDW (Analytic Platform System)
• Troubleshoot SQL Server, including performance problems, query tuning and optimization, and Windows Server performance problems
• Provide on-site and remote technical support solutions for customer service delivery and availability, while ensuring satisfaction with Microsoft SQL server.
• Provide field technical support presence for groups in the Microsoft Services organization, including but not limited to Premier Support and Microsoft Consulting Services.
• Act as the primary onsite technical contact, providing customer visibility, advanced technical support and problem resolution for corporate customers, including issues escalated to the highest levels of management.
• Act as a resource for on-going SQL planning and deployment
• Help with analysis of Upgrade/Migration to a new SQL environment
• Provide SQL workshops and training for customer's existing support staff (AlwaysON Availability Groups, SQL 2014 New Features and SQL Server Health Checks)
• Deliver timely and high quality solutions to customer problems and requests focusing on root cause analysis, prevention, knowledge transfer, and opportunity generation. Manage escalations and sub-cases to ensure timely and high quality resolution of all issues.
• Develop and implement strategies for providing facilitative support resulting in fewer incidents, increased availability, or accelerated deployments.
• Develop relationships with technical directors or lead architects for the technology you support resulting in more participation in planning and improved satisfaction in support consulting.
• Partner with Premier Technical Account Managers to effectively manage hot-sites including documented action plans and daily status updates for the customer and Microsoft management.
• Develop a working relationship with MCS and field staff at your accounts that results in increased cooperation and mutual support in achieving each other's goals.
• Initiate and participate in triage meetings to share knowledge with other engineers and to efficiently resolve customer problems.

Confidential, Reston,VA

SQL Server DBA/Consultant

• Install SQL server 2008R2, 2012 and configure database servers with Confidential regulations and post installation polices
• Implements database policies, security and create documentation for complex tasks
• Assist Project managers and junior DBA with any issues
• Provide technical expertise in database area throughout the life cycle of all projects
• Implement High Availability and Disaster Recovery using clustering, mirroring and log shipping and Always ON Availability Groups
• Troubleshoot and Performance Tune SQL Server with PSSDIAG/PAL/SQL Nexus/xEvents/DMVs

Confidential, FL

SQL Server DBA

• Provide primary support for SQL database environment and application.
• Analyze data performance, adjusting indexes and other methods to improve performance and report on any queries developers are using that are negatively impacting performance.
• Write, maintain, and monitor appropriate SQL Jobs and ETLs as needed to transform and load data feeds from and to vendors and clients.
• Install SQL server on Production and Test environment for Flexera and Microsoft SCCM.
• Ensuring proper schema and data is created, adjusted, and applied as necessary to appropriate environments when code has been deployed.
• Provide 24/7 support for critical situations
• Evaluate and recommend new database standards and technologies
• Provide support for database development and support in MS SQL Server environments.
• Work with SQL Server 2012, SQL Server 2008 R2 and SQL Server 2005
• Analyze, consolidate and tune databases for optimal efficiency.
• Build database scheme, tables, procedures and permissions
• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention using DMV, Profiler and third party tools
• Setup backup/restore processes and jobs
• Create Automated Replication Processes using SSIS and SSRS reports for BMC Marimba database.
• Create appropriate stored procedures, functions, tables, views, indexes, constraints, and triggers

Confidential, Washington D.C

DBA

• Control the activities related to database planning and development:
• Perform software installation, upgrades, and configuration.
• Perform data analysis, database design and creation, and data modeling and optimization.
• Assists with establishing policies and procedures pertaining to database management, security, maintenance, standards, and utilization.
• Installation and configuration of SQL server 2005/2008/2012 and latest service packs
• Work with SSIS and SSRS with SharePoint integrated, Replication and SQL Clusters and Mirroring and SQL 2012 Always ON
• Plan and monitor security of databases by setting and restricting database access;
• Manage and perform detailed testing of database objects and scripts and perform code reviews
• Ensure data integrity through implementing constraints, creating and maintaining data manipulation processes and performing standard database maintenance
• Create and maintain contingency plans for data, including backup/recovery and replication with sys admin
• Ensure efficiency of queries and proper indexing on database tables
• Work with the Network and System Engineers to make sure the physical or VM servers are built correctly for SQL Server use.
• Monitor and manage database backups, log and journal
• Make data management decisions, such as placement of databases and backups
• Determine system capacity for planning
• Research Third party tools and how to implement them in our environment.
• Use the SQL Server Profiler tool and DMV to monitor the performance of SQL Servers
• Work with SharePoint Administrator for better SharePoint SQL performance

Confidential, NJ

DBA (contract)

• Installation and configuration of SQL Server 2000, 2005 Oracle in various servers
• Creating tables, indexes, synonyms, stored procedures, triggers, views, materialized views in SQL Server 2000/2005 and Oracle
• Creating some shell scripts to run export and import backups or manual reload
• Tuning various SQL/PL SQL codes to maximize result time, tuning application codes.
• Work on some data modeling using Microsoft Visio
• Migration of IBM Oracle Servers to AT&T SQL servers while we were administering and supporting some of IBM production databases.
• Ensuring that Computer Security Policies are followed
• Monitoring database and machine performance / troubleshooting database performance problems

Confidential, Washington D.C

Database Analyst/ Data Security Administrator (contract)

• Installation and configuration of Oracle 9i, SQL Server 2000 Databases
• Backups and restoration of databases.
• Providing support to the Security team activities as far as ID creation, deletion, Creating DB links, synonyms, setup of various roles and profiles
• Migrate various objects and function from test to production
• Daily maintenance review, SQL optimization, disaster recovery planning
• Provide work samples for quarterly Sarbanes-Oxley audits to verify compliance with security procedures
• Working as a team member with other DBAs to ensure 24hour x 7 a week support of all databases
• We have about 10 oracle servers and 15 SQL servers
• Work with various applications like, UNIX on AIX platform, PeopleSoft interface, Lawson, E-Trust access for managing user access and security classes, process flows and migrations.

Confidential, Washington D.C

Database/Business Objects Analyst

• Creates and develops software solutions to application errors reported using Oracle Forms and Toad
• Design a logical workflow steps for various applications: Web Nar, some SQL server Databases, Oracle, Nar cube and Profit Access.
• Manage Inbox and provide assistance for system access requests and issues for 900+ Oracle database and 4500+ Business Objects reporting users.
• Provide work samples for quarterly Sarbanes-Oxley audits to verify compliance with security procedures.
• Create and update SQL queries, notifications and workflow process documentation
• Creating tables, views, indexes, and synonyms required to meet client needs
• Creating physical database from logical data model.
• Backing up databases using Oracle’s export utility, RMAN, hot and cold backups.
• Having good knowledge of SQL*Loader.
• Providing remote technical support using SSH and terminal services
• Creating shell script to administer and monitor the database up and downtimes