Michael Ye

Experience

• 

  Priceline

  Apr 2003 - Jun 2005

  DBA/Database Developer

  • Designed DTS package in SQL Server with store procedure and VB program for online hotel transaction. • Maintained LOOKER, BOOKER and various databases for online hotel booking process. • Extracted booking information and processed transactions to data warehouse.• Supported front end application and website engine. • Implemented bash, ksh, and csh shell scripts in CGYWIN and Linux environment. • Designed SQLAgent jobs for data refinery, data warehouse and various operations. • Processed booking, canceling, and adjustment information of hotel reservations.• Generated financial analysis daily and monthly reports.• Created GL entry for the financial detail and post it to Solomon. • Created user interface for financial database using .NET components such as ASP.NET, VB.NET, and .NET framework.• Converted SQL Server database to Oracle using PL/SQL, SQL Loader, shell script and SQL Plus. Show less

• 

  True Automation

  Aug 2005 - Jul 2007

  DBA/Database Developer

  • Designed and normalized databases, tables and view for hundreds of county appraisal/tax districts.• Designed the database in MS SQL Server 2000, created and implemented specifications of SQL Server stored procedures.• Data systems built using MS SQL 2000/DTS/MS OLTP including multiple 20+GB ODS for property search, tax calculation and ARB protest.• Implemented stored procedures and functions to improve performance by 10 times.• Automated reconciliation process for millions of appraisal cards and tax statements for San Antonio, Austin and Collins counties in T-SQL.• Designed backup and restore plan for emergency recovery.• Created the sophisticated queries necessary to retrieve, summarize, and format information for use by analysts and executive decision.• Created cluster and non cluster indexes to boost query and real time database performance. Show less

• 

  EMSI

  Aug 2007 - Oct 2009

  Senior Database Administrator

  • Migrated SQL Server 2000 to SQL Server 2005 and Converted DTS packages to SSIS.• Managed 20+ live production SQL Server 2000/2005 DB, Analysis Server and Reporting Servers comprised of terabytes data.• Provided Engineering and Operations staff with guidance on the creation of queries and stored procedures.• Responsible for the design and implementation of new stored procedures and the refactoring of existing stored procedures to meet new requirements or enhance functionality, typically from a set of functional specifications.• Generated annually, quarterly, monthly and daily report using MS Reporting Service and SQL Agent.• Tuned tables, indexes, queries and stored procedures using perfmon, SQL Server Profiler and query execution plan for optimal performance.• Designed disaster recovery strategy plans for different scenario like hardware, software, power failure.• Worked in a Windows Cluster environment on both Active/Active and Active/Passive setting.• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.• Programmed DTS, SSIS, Stored Procedure for Data Migration, Conversion, Import and Export from various data source like Excel, Access, Oracle, Text File, DB2, and SQL Server. Show less

• 

  Tyler Technologies

  Nov 2009 - Nov 2017

  Conversion Architect

  Conversion Architect• Converted court and justice information to case manager, attorney manager, jail manager supervsion products from various county and state government including Fulton GA, Orange CA, Dallas TX and etc.• Designed and implement ETL process to convert court and justice data from various data sources including flat file, SQL server and Oracle to MS SQL server database.• Collaborated with project management and business analysts to develop data conversion packages that meet client business requirement.• Created and updated conversion logic to resolve client issues in test and production environments• Engaged in query performance tuning on long running ETL processes.• Designed, implemented, and maintained new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion utilities and projects.• Mentored Conversion Developers and Associate Conversion Developers.• Tune and optimize database objects, queries, and scripts for speed and efficiency in support of data conversion, conversion utilities, and various data related projects.• Perform SQL Server administration activities (backup, restore, DBCC commands, indexing, shrink)• Performed complex data analysis to identify pattern, anomalies and exceptions. Show less

• 

  PGIM Real Estate

  Nov 2017 - now

  - Develop and maintain highly complex SQL procedures and functions- Backup, restore, and conduct change scripting on SQL Server databases across multiple environments- Build and maintain SSIS packages- Maintain interfaces with various 3rd party applications via SSIS and Linked Servers- Configure new SQL Server environments- Perform analysis and database tuning- Develop recommendations for database design and prepare detailed specifications- Research new SQL Server releases and advise team on course of action- Support SQL Server Reporting Services platform- Work closely with business community and provide ad hoc reporting…see moreTitleSenior Database SpecialistDates EmployedNov 2017 – May 2019Employment Duration1 yr 7 mosLocationDallas/Fort Worth Area- Develop and maintain highly complex SQL procedures and functions- Backup, restore, and conduct change scripting on SQL Server databases across multiple environments- Build and maintain SSIS packages- Maintain interfaces with various 3rd party applications via SSIS and Linked Servers- Configure new SQL Server environments- Perform analysis and database tuning- Develop recommendations for database design and prepare detailed specifications- Research new SQL Server releases and advise team on course of action- Support SQL Server Reporting Services platform- Work closely with business community and provide ad hoc reporting Show less - Develop and maintain highly complex SQL procedures and functions- Backup, restore, and conduct change scripting on SQL Server databases across multiple environments- Build and maintain SSIS packages- Maintain interfaces with various 3rd party applications via SSIS and Linked Servers- Configure new SQL Server environments- Perform analysis and database tuning- Develop recommendations for database design and prepare detailed specifications- Research new SQL Server releases and advise team on course of action- Support SQL Server Reporting Services platform- Work closely with business community and provide ad hoc reporting Show less - Develop and maintain highly complex SQL procedures and functions- Backup, restore, and conduct change scripting on SQL Server databases across multiple environments- Build and maintain SSIS packages- Maintain interfaces with various 3rd party applications via SSIS and Linked Servers- Configure new SQL Server environments- Perform analysis and database tuning- Develop recommendations for database design and prepare detailed specifications- Research new SQL Server releases and advise team on course of action- Support SQL Server Reporting Services platform- Work closely with business community and provide ad hoc reporting Show less

  • Director - Database Administration

    Mar 2021 - now

  • Manager Database Administration

    Jun 2019 - Mar 2021

  • Senior Database Specialist

    Nov 2017 - May 2019