SUMMARY

• Energetic, highly motivated, organized IT professional with 12+ years of experience in a dynamic and fast paced environment. Able to bring process and discipline to rapidly growing IT environments. Ability to interact with wide variety of associates including senior management, technical, business and project management associates.

TECHNICAL SKILLS

• Office 2000/XP/2016 SQL Server PowerShell Windows XP/Vista/Windows 10
• Microsoft Visio/PowerPoint Oracle 9i/10g JAVA Windows Server 2003/2016
• SSRS/SSAS/SSIS/BIDS MySQL ASP/ASP.Net UNIX/Linux
• Crystal Reports PostgreSQL HTML/DHTML
• Athena Aurora VB Script
• Athena Python
• Redshift

PROFESSIONAL EXPERIENCE

Confidential

Cloud Database Administrator

Responsibilities:

• Responsible for designing, implementing, and maintaining high - availability SQL databases in a SaaS environment.
• Responsible for migrating “on premises” database environments to AWS.
• Work with customers to plan migration of their database to RDS engines
• Advise customers on troubleshooting and diagnostic activities as they run their databases on AWS.
• Setup, monitoring and maintenance of high availability and disaster recovery methods (mirroring, replication, clustering, backups).
• Collaborate with a variety of business engineers to optimize and manage virtual and hardware resources.
• Develop and implement backup, recovery, and cloning solutions for database systems (SQL Server, MySQL, Aurora, Redshift, Athena).
• Write scripts in PowerShell/SQL to automate maintenance tasks such as database clones, monitoring, and backups.
• Performance tune and troubleshoot database systems in the cloud (SQL Server, MySQL, Aurora, Redshift).
• Leverage native AWS tools for database migrations (DMS).
• Manage multiple projects simultaneously and adapt to changing business goals.
• Publish and/or improve technical documentation along with processes and procedures.

Confidential

Cloud Database Administrator

Responsibilities:

• Building and maintaining production systems on AWS using EC2, RDS, S3.
• Managing RDBMS in the cloud (SQL Server, MySQL, Aurora, Redshift).
• Managing/Building High Availability (HA) and Disaster Recovery (DR) solutions for SQL Server. AlwaysOn technology, Replication, Log shipping.
• Database monitoring, integration, replication, notification, analysis, tuning, problem resolution, reporting and production support.
• Provided 24X7 support for mission critical database systems

Confidential

SQL Server Database Administrator

Responsibilities:

• Modeled database systems for performance and scalability.
• Designed and implemented Data Warehouse
• Used SSIS to develop multiple ETL Process to retrieve flat files from vendor and dynamically load the tables in the Data Warehouse on a recurring basis.
• Monitor and proactively plan for database expansion and performance by understanding the business growth, plans and requirements.

Confidential

SQL Server Database Administrator

Responsibilities:

• Build and maintain Windows Server Failover Clusters (WSFC) for the database and application servers.
• Implement log shipping and AlwaysOn in SQL Server 2012 and SQL Server 2014.
• Performance tuning OLTP databases.
• Review all migration scripts for changes into production for all applicable applications, operating systems, and hardware to ensure departmental migration standards are followed.
• Working with development team in evaluating, writing, and debugging T-SQL, stored procedures, and ad-hoc querying.
• Managing referential integrity between databases, including all scripting, triggers and stored procedures.
• Developing monitoring and alerting functions related to SQL (Idera).
• Adhere and enforcing change control and release procedures.
• Define and advise on opportunities for improvement on SQL Server security
• Identify and enforce enhanced logging and relevant security controls within Microsoft SQL Server.
• Review system and Microsoft SQL logs for unexpected entries and audit logging.
• Maintain user access administration and auditing.

Confidential

Production Support Database Administrator

Responsibilities:

• Responsible for disaster recovery, capacity planning, real-time monitoring, troubleshooting, and proactive maintenance.
• Educating and advising internal customers on how to leverage available data for consumption.
• Responsible for regular maintenance of production, test, and development databases.
• Responsible for backup/restore procedures.
• Responsible for troubleshooting and problem solving of SQL Server.
• Work with developers to troubleshoot application problems.
• Testing of operating system upgrades with database engine.
• Support and manage our dynamic 7x24 Production SQL Server environment.
• Successfully migrated 200+ databases from SQL 2000 to SQL 2008 R2.
• Successfully assisted with creation of VB.Net application to automatically enable database mirroring.
• Successfully assisted with creating reporting mechanisms to assist with monitoring and managing the backup process.

Confidential

Database Administrator

Responsibilities:

• Direct and control activities relating to database management, planning, development, security, upgrades, patches and maintenance.
• Monitor the health of databases, troubleshoot and resolve problems.
• Promote DDL Changes to QA and Production.
• Support database mirroring while ensuring availability.
• Implemented backup and maintenance solution for all database systems.
• Successfully migrated from SQL 2005 to SQL 2008 R2 on main POS application.

Confidential

Database Administrator

Responsibilities:

• Monitor and optimize database performance, security and access to database.
• SQL Server planning, design, implementation, upgrades and documentation.
• Create primary database storage structures, database objects, migration scripts to modify structures and objects.
• Disaster recovery, capacity planning, real-time monitoring, troubleshooting, and proactive maintenance.
• Assist programming teams with the development of databases, triggers, store procedures, and other development related tasks.
• Responsible for improvement and maintenance of the databases to include rollouts and upgrades.
• Administer database security across all database environments.
• Support/Utilize Business Intelligence based Tools (SSIS, SSAS, SSRS) for BI solutions.
• Configured and ma Log Shipping, SQL mirroring, and Replication.
• Created departmental policies and procedures governing interface design, testing procedures, hardware requirements for client implementations, and technical documentation.
• Managed implementation of the development environment and quality assurance environment.
• Developed process flow for database deployment to staging and production environments.
• Established and maintained security policies and standards for SQL Server systems and databases.

Confidential

Database Administrator/Developer

Responsibilities:

• Successfully migrated from MS Access database to SQL Server database.
• Resolution of issues through clarification of workflows or system behavior, provision of database scripts, configuration changes recommendations or escalation to development.
• Responsible for ensuring availability and performance of the databases that support the system.
• Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.
• Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
• Responsible for troubleshooting and problem solving of SQL development.
• Responsible for implementation and release of database changes according to agreed timescales and costs.
• Responsible for database alerts, maintenance plans and scripts.
• Created departmental policies and procedures governing organizational security, email, internet usage, and access control.
• Lead efforts to guide team to best practices for database usage, high availability and business continuity.
• Analyzed existing database application and improved functionality on existing platform.