PROFESSIONAL SUMMARY:

• 11+ years of experience in different phases of software development life cycle including analysis, design, development, documentation, deployment and system support.
• 10+ years of experience as Database Developer and 8+ years of experience as Database Administrator.
• Experience in SQL Server / 2000/ 2005/2008/2008 R 2/2012/2 /2019 , SQL, T - SQL, Always On Availability Groups, SQL Server Failover Clustering, Mirroring, Log Shipping, Stored Procedures, Triggers, BCP, DTS, SSIS packages, Crystal Reports, Oracle 9i/10g, PL/SQL, SQL Plus, VSS.
• Advance knowledge in RDBMS concepts, conceptual/logical/physical data models.
• Expert in Performance Tuning and Optimization of SQL Server, SQL scripts and Stored Procedures.
• Experience in implementing Backup & Restore (Full, Differential and Transactional) procedures, Log Shipping and Transactional Replication.
• Designed, developed and deployed large and complex ETL projects using SSIS.
• Providing weekly rotation on call supports for production environments and creating infrastructure documents and operations guides for Level1 support teams. Also, Installation of patches, fix packs and deployment of applications on WebSphere, Tomcat and WebLogic servers.
• Experience in application development using Microsoft Technologies such as C#, Visual Basic.Net, ASP.Net, Visual Basic.
• Experience in Windows Server Infrastructure, Active Directory, IIS.
• Strong analytical, problem solving and troubleshooting skills.
• Expert managing Azure SQL Database, Recovery Services Vault.
• Able to work collaboratively, quickly understand system architecture and business needs while committed to achieving corporate goals. Good verbal and written communication skills.
• Ability to work independently and in large team environment.
• Ability to learn new skills on the job.

TECHNICAL SKILLS:

Operating Systems: Windows Server, Linux

DBMS: MS SQL Server, Microsoft Access, MySQL, Oracle, Progress

Programming Languages: Visual Basic.net, C, C++, C#, MATLAB

Infrastructure: Active Directory, IIS, Apache, Database Servers, TCP/IP, DNS

Scripting: PowerShell, Bash, Phyton

Cloud Technology: Azure VM, Azure SQL Database, Recovery Service Vault, Azure BLOB Storage, Azure Monitor, Cosmos DB, Application Insight

Monitoring Tools: SolarWinds DPA, AppDynamics, SiteScope.

EDUCATION AND CERTIFICATION: Master s Degree in Information Technology Management, TecMilenio University, M xico Bachelor s in Computer Sciences, UADY, M xico

Microsoft Certified Professional: MCTS, SQL Server 2008, Implementation and Maintenance MCTS, Windows Server 2008 Active Directory, Configuration

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Cloud Database Administrator

Responsibilities:

• Assists with various teams with database environment project plans/timelines, resource needs and identify project infrastructure requirements.
• Azure Migration.
• Assumes ownership for data model and underlying data associated with systems assigned.
• Maintains critical database and infrastructure at prescribed levels, and in notifying management and user communities when service levels are at risk.
• Maintains internal and customer-facing system availability at acceptable service levels.
• Maintains open lines of communication between JDA teams, external vendors and customers.
• Notifies management and external vendors when service levels are not met.
• Expedite resolution as required, to maintain acceptable customer satisfaction.
• Provides guidance, feedback, coaching, and developmental experiences to other JDA, project teams or JDA associates to encourage teamwork and a positive work environment.
• Provides regular project communication and status reporting to the appropriate JDA associates to inform them of current and future activities, concerns and project issues.
• Recommends backup schedule in relation to batch processing and user access considerations.
• Works with external vendor support teams to resolve application, hardware and software related issues associated with database software.
• Works with JDA Associates to define JDA product database functional/technical requirements and project needs.
• Works with vendor support teams to resolve database management system related issues for external-facing systems to maintain acceptable service levels.
• SQL Server maintenance tasks automation with PowerShell.

Environment: Azure VM, SQL Server 2008/2008 R 2/2012/2 /2019 , Windows Server 2008, 2008R2, 2012, 2016 .

Confidential, Monterrey, MX

Sr. SQL Server Database Specialist

Responsibilities:

• Database development and administration in SQL Server 2005/2008/2008 R 2/2012/2014/2016 environment.
• Assist in analyzing, developing, and implementing the physical database design in support of stated project requirements.
• Reviews, evaluates, designs, implements and maintains databases. Work with Development team on new feature set for product release.
• Provide leadership and mentoring to other DBA and Development team members.
• Work directly with customer base to help resolving high level performance issues as it relates to the SQL Server database.
• SQL custom projects that involves ETL, using SSIS. Analyze future SQL Server versions and provide areas that would be beneficial for our products.

Environment: SQL Server 2008/2008 R 2/2012/2014/2016 , Windows Server 2008, 2008R2, 2012, SSIS, SSRS.

Confidential, Great Neck, NY

Sr. SQL Server DBA Consultant

Responsibilities:

• Consulting SQL Server services including: Installation, Administration, Performance Tuning, Backup, Recovery, Production support, Troubleshooting, Implementation, Migration, Upgrade, Testing and Maintenance of MS SQL Server 2000/ 2005/2008/2008 R2 databases.
• Disaster Recovery Plan designs and SQL Server Databases on Cluster instances implementations.
• Installation and implementation of reports using SQL Server Reporting Services (SSRS). ETL tasks, migration of Data from Excel and Flat file to MS SQL Server by using BCP, DTS and SQL Server Integration Services (SSIS) utilities.
• Database migrations from SQL Server 2000 to SQL Server 2005 and 2008. Database modeling, collaborating with application development teams.

Environment: SQL Server 2008/2008 R2/2012, Windows Server 2008, 2008R2, 2012, SSIS, SSRS

Confidential, Monterrey Area, MX

Database Administrator

Responsibilities:

• Establishing the needs of users and monitoring user access and security, Installing and testing new versions of the database management system (DBMS).
• Writing database documentation. Controlling access permissions and privileges, developing, managing and testing back-up and recovery plans. Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly. Working closely with IT project managers, database programmers and web developers.

Environment: SQL Server 2005, SQL Server 2008, SQL Server 2008R2, Oracle 9i, Windows Server 2008, 2008R2, SSIS, SSRS, SSAS, Microsoft IIS, Linux servers.

Confidential, Monterrey Area, MX

Sr. System Engineer

Responsibilities:

• Analysis, design and development of an interface system to link the company CRM (GPS) and the company ERP (BAAN).
• Automate the construction of the Bill of Materials List (which up to date is being done manually) for the products quoted within the CRM software and then match the materials gotten from the CRM (using XML tags called intellicodes) to the materials real stock from the ERP (BAAN).

Environment: MS SQL Server 2008, ASP.Net, C#, XML, Jscript, .NET Ajax Toolkit, BAAN