Luis Castillo Email & Phone Number

Seattle, Wa, Us

Deliver new experiences to Prime Video Live Sports Fans!

Seattle, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

• Principal DBA for designing Database infrastructure for Global Incentive Commission System.• Provide and implement High Availability for Database Infrastructure.• Design and Implement Backup strategy using AWS S3.• Develop and Implement ETL packages using SSIS and Link Servers to/from Oracle Databases and CSV files, to:o Automate external feeds into the database.o Automate Commission payouts into HR Payroll system.o Move geographical data useful for other systems and avoid re-work.• Database size reduced by 60% simplifying Commission Calculations.• Design and Implement Custom reports for Different regions.• Involved in dev (third-party application) activities to review, enhance and improve consultants work. • Architect and Implement MBO Plans.• Generate test cases/scenarios for application from requirements.

Bangalore, Karnataka, In

• Microsoft SQL 2012 Migration Project, Migration of database servers from SQL 2005 to 2012 for a High demand system. Hands on AlwaysOn Sync-HA setup and support. Redesign transactional replication to work with AlwaysOn. Create automated scripts for SQL install, setup, migrate, implement incompatibility issues and fixes and AlwaysOn. Migration of SQL Jobs to be operational with AlwaysOn and take advantage of read-only secondary replicas when possible. Migrate and support lower, test and performance environments. Missing Index creation and Stored Procedure performance tuning. Analyze and Purge necessary data according to business specifications. Provide solutions to issues for DTS to SSIS migration.• Microsoft SQL DBA support for existing lower, test and performance environment for all the systems.• Improved performance in .net applications using partitions.• Automate Replication build and deployment.• Support database and application deployments.• Provide guidance and best practices to SQL Developers.

Bangalore, Karnataka, In

Microsoft SQL DBA support for existing lower, test and performance environment for all the systems.• Improved performance in .net applications using partitions.• Automate Replication build and deployment.• Support database and application deployments.• Provide guidance and best practices to SQL Developers.

• Principal SQL DBA on the company providing High Availability for all the application and avoid single points of failure. Monitor SQL server performance and usability. • Manage application jobs and alerts within instances.• Maintenance jobs and regular maintenance tasks that include database integrity, database backup strategy, backups integrity, index rebuild/reorganize and query tuning. • Design and Implement a Quote/Order Processing system which allows sales man to provide faster quotations, faster order processing, accurate information when needed and paperless cycle.• Create an extended module for a Warehouse Management System which provide accurate location and easy to use procedure, implementing barcodes and labeling identification.• Create automated scripts import users pst file into user’s Exchange Mailbox.• Implement Security Policies on user’s computer and servers to maintain security and unification across the company.

Nordborg, Dk

• Active participation on Windows Server and User’s computers migration to Windows 2003 Global Active directory and Global standards in multiple locations within the US.• Network Infrastructure and PBX Support.• First and Second Line Technical Support in Internal Help Desk giving primary support to Danfoss US, Denmark and Latin America.• Collect requirements from internal customers and create custom reports. (Finance and Production Lines)• Generate new reports ideas for better decision making.• Drill down reports creation for optimum data mining and understanding using Cognos Impromptu.• Analyze and Implement Microsoft Access Projects which avoided typing errors reducing man power, increasing production capacity. Data was structured in a better way which allows getting faster reports for daily meetings and decision making.

Ingeniero Administrador De Sistemas, Networking

Education record