Jared Ong Email & Phone Number

New York, Ny, Us

New York, Ny, Us

Medidata Solutions is the leading global provider of cloud-based solutions for clinical research in life sciences. Our innovative technology is used by over 400,000 people every day and helps streamline the clinical development process--ultimately enabling life sciences organizations to conduct their clinical trials faster, safer, cheaper and smarter.Our client base accounts for more than 50 percent of global research and development efforts and includes 90 percent of the top 25 pharmaceutical companies, as well as numerous leading medical device manufacturers, contract research organizations (CROs), and academic institutions. We are consistently rated among the top medium sized companies to work for. That's because we provide new innovative challenges for people from every discipline, from engineers and scientists to marketing, legal, accounting, human resources, and more!

Bee Cave, Texas, Us

- Promoted from Database Administrator to Sr. Database Administrator to Data Architect - Architected data model improvements for core Bridgeway software products: eCounsel, Secretariat, LegalHold, and Corridor- Developed database upgrade scripts for core Bridgeway software products: eCounsel, Secretariat, LegalHold, and Corridor- Administered 100s of client databases as well as 100s of development databases- Administered 10+ Oracle 12C, 11G, 10G, and 9i instances- Administered 20+ SQL Server 2014, 2012, 2008 R2, 2008 R1, 2005, and 2000 instances- Developed and tuned stored procedures, triggers, and views utilizing PL/SQL and T-SQL- Performed data migrations, upgrades, and data conversions- Utilized SQL Server Profiler and Oracle Trace - Tuned slow database queries and modified indexes to achieve optimal query performance- Installed SQL Server and Oracle in clustered and non-clustered production environments- Administered and installed database software in Linux and Windows environments- Developed and implemented disaster recovery backup and restore procedures- Utilized RMAN, impdp/expdp to backup and restore Oracle databases- Utilized Full, Differential, and Transaction Log backups for SQL Server databases- Mentored agile team members on best practices and development standards- Acted as 4th tier client support to diagnose and troubleshoot suspected database issues- Developed data fix scripts to resolve data integrity issues and software bugs- Developed NoSQL database schemas utilizing Cassandra, Datomic, and ElasticSearch

College Station, Tx, Us

- Promoted from Support Services Technician to Quality Assurance Analyst to Web Application Developer to Database Administrator- Automated backup and recovery process for 11 Oracle 9i Database Instances, 6 SQL Server 2005 Instances, 5 SQL Server 2000 Instances, and 5 mySQL4 Instances.- Performed periodic data refreshes of production data into test and development- Utilized problem solving skills to locate and report poorly performing queries- Optimized execution plans through index additions, query tuning, and materialized views- Performed database maintenance including security patches, service packs, index rebuilds- Designed and maintained 20+ Crystal Reports- Utilized batch and shell scripts to automate routine database tasks- Maintained documentation of server information, database software, and patch levels- Tuned server memory, disks, and init parameters to improve database response times- Developed enhancements for core K2Share software products: SPARS and Preceptor- Utilized Coldfusion, ASP, HTML, and Javascript to improve K2Share software- Improved data quality by adding referential integrity and normalizing database schema - Designed and developed data feed for 50,000+ users from 4 source HR systems