| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name Cheang EMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFILE:|10 Years as a Database Administrator ||2 Years as Application Support consultant ||1 year of experience as a Web Developer/Content Manager ||1 year of experience as a Quality Assurance Engineer and Application ||Developer || |PROFESSIONAL EXPERIENCE:Pactera - Client: Microsoft Redmond, WA DatabaseAdministrator From: 08/19 Present . Working on alwaysOn, Azure ADF, powershell automation and planned maintenance tasks. . Providing Azure support, on-prem db's to IaaS migration, Cosmos regional failovers and data migrations. . Collaboration with infrastructure teams for decommissioning, patching, maintenance and troubleshooting. . Assisted with TLS security enforcement with coordinated smoke tests among payment replication systems. . Added automation database solution to support data convergence analytics. . Modeled data, built and deployed PowerBI reports to visualize and asses incident management tickets. . Monitoring and troubleshooting reliability for integrated token services for mission critical payment systems.Environment: SQL Server AlwaysOn, OLTP NoSQL, Replication, PowerBI, Azure,DevOps, Cosmos, Commvault.Tata - Client: XL Group Queretaro, Mexico DatabaseAdministrator From: 03/15 06/18 . Follow-up ServiceNow ITIL based requests, incidents, cutover changes, monitoring and calls. . Setup Replication, Linked Servers, performance tuning on SQL Server environment . Worked closely with developers to identify slow performing queries and tune them by improving design patterns and provide index tuning. . Handle Admin tasks on Informatica, SSRS Reports and SSAS cubes, security segregation duties. . Verify cluster server's availability and troubleshoot failures related to infrastructure and storage team issues. . Attended Change Management and SOT Calls to collaborate with other IT team areas during critical production incidents.|Tools: |SQL Server 2005-2017, Windows Server 2008, 2016, Idera || |Litespeed, Informatica. |Softtek - Client:Staples Aguascalientes, Mexico DatabaseAdministrator From: 02/14 02/15 . Installation and configuration, Database monitoring, establish performance baselines for servers . Assist on production releases and server Load testing. . Perform database backups and database refreshes, review and execute changes. . Aided the design of an isolation level change to eliminate contention in a critical production database. . Implement automation database maintenance tasks using PowerShell and SSIS . Perform database growth capacity planning|Tools: |SQL Server 2005-2012, Windows Server 2008, 2012, Idera, || |RedGate, PowerShell. ||Softtek -Client: GE |Aguascalientes, |Database |From: |02/14 ||Treasury |Mexico |Administrator |12/10 | | . Monitoring databases, evaluating upcoming alerts, engaging Application support or Infrastructure teams. . Collaborated with Development and Application teams to implement QA and Production Releases . Assistance to Maintenance and Disaster Recovery drill windows collaborating with infrastructure teams. . Provide Database access and account permissions through controlled workflows. . Elaborate on incidents or report findings of database or infrastructure related issues. . Worked with Windows Admin team to perform controlled service resets and operating system related issues . Conduct code reviews of TSQL scripts; create traces for troubleshooting performance issues. . Perform health checks on database services and availability during server patch maintenance windows|Tools: |SQL Server 2000-2012, Windows Server 2003, 2008, Lite || |speed, Citrix,Vmware ||Softtek - |Aguascalientes, |Database |From: |To:12/1||Client:McKesson |Mexico |Administrator |04/09 |0 | . Hands on daily database monitoring, evaluate alerts and maintenance checklist . Perform standard database operations including exports, imports, table restorations . Provided resolutions and RCA of upcoming incidents under 24x7 support duties and incident management. . Contacted Server infrastructure teams and Storage teams for assistance or escalations . Implementation of SQL Server virtual workstation environment . Wrote SOPs to collaborate, standardize tasks for best practices with DBA Team.|Tools: |SQL Server 2000, 2005 2008, SSIS, Reporting Services, || |Litespeed, VMWare. || | ||Softtek -GE Commercial |Aguascaliente|Application |From: |To:04/0||Finance |s, |Support |06/07 |9 ||Application support to calling agents and business application owners. ||Coordinated Application Control changes and collaborated with different IT ||teams to resolve issues ||Implemented data transformation scripts (ETL) in sql server for gathering ||Fleet accounts from application database and map the formatted data into a ||server folder to be used by an external application. ||Used SSIS tools to import vehicle account information into the application ||database from external business sources. ||Guided Business intelligence team to answer questions related to the use of ||the application's data warehouse. ||Worked with vendor on new requirements and analysis for application ||enhancement changes. ||Communicated technical issues to different Vendors and inquired ||effort-estimation requirements ||Functional |Attention and follow-up with production issues, acquired ||Experience: |onsite vendor knowledge transfer ||Tools: |SQL Server 2000, 2008, SSIS, Excel vlookup, SOAP UI, XML, || |Quality Center, Mainframe. ||Softtek - GE Money |Aguascalientes|Project |From: |06/07 || |, Mexico |Leader-Web |04/06 | || | |Content Manager | | ||Main point of contact for developing, testing and sending out email ||marketing campaigns working closely with product managers and direct ||marketing team. ||Developed web forms and incorporated additional website tools, configured ||server files for email / contact forms ||Played active role in the release to production of GE Money Websites for ||different countries. ||Created functional specifications and blueprints for online banking system. || | ||Functional |Strong commitment to client service handled project ||Experience: |management under CMMi. ||Tools: |Interwoven TeamSite 6.7, Responsys, PhotoShop, Java || |Script, HTML, XML, CGI. ||Code Services Co. - |Ensenada, |Quality Assurance|From: |To: ||ProPricer |Baja |Engineer |04/05 |04/06 || |California | | | ||Worked with offshore QA team for the development and maintenance process of ||proposal pricing system. ||Tested and verified System enhancements to track defect, security, usability||issues and isolate error detection. ||Responsible of the maintenance of internal test tool in VB6 for database ||upgrades. ||Functional |Defect issues, development processes, Data-Driven Testing ||Experience: |and planning, unit testing. ||Tools: |Rational Visual Test, MS Visual Basic 6, MS Visual Source || |Safe , PL/SQL, Oracle9i, XML. ||CICESE Research Center -|Ensenada, |Application |From: |To: ||Applied Physics |Baja |Developer |02/04 |02/05 || |California | | | ||UML architecture specification of Agent Directory based framework. ||Client/Server applications implementation using java technology - DSML to ||XML transformation. |EDUCATION:|Universidad Autnoma de Baja California |Ensenada, |1999-2004 || |Mexico | ||Bachelor's Degree in Computer Science | | ||LANGUAGES: Spanish native, English Advanced Level - TOEIC Certified |TECHNICAL/MANAGERIAL SKILLS:|Primary Profile: |Database Administrator SQL Server with Azure and Cosmos|| |Experience. || | |PERSONAL DATA:|Martial Status: |US Visa Expires: |DOB: 13/03/1981 | ||Single |2022 | | | |
