Cini Thomas Email & Phone Number

Tacoma, Washington, United States

Auburn, Washington, United States

• Managed database instances in Azure/AWS.• Designed and developed ETL processes using SSIS packages as per business requirements. • Migrated on-prem database to IAAS and PAAS and managed the databases in cloud.• Database development in Postgres, SQL Server and Oracle for multiple customers.• Managed OLTP/OLAP (data warehouses) systems.• Trouble shooting and fine-tuning of databases for its performance. • Developing TSQL Scripts (Functions, Stored Procedures, Triggers… Show more • Managed database instances in Azure/AWS.• Designed and developed ETL processes using SSIS packages as per business requirements. • Migrated on-prem database to IAAS and PAAS and managed the databases in cloud.• Database development in Postgres, SQL Server and Oracle for multiple customers.• Managed OLTP/OLAP (data warehouses) systems.• Trouble shooting and fine-tuning of databases for its performance. • Developing TSQL Scripts (Functions, Stored Procedures, Triggers and Views)• Installing, configuring, managing, upgrading, migrating, monitoring, and troubleshooting SQL server.• Optimized code and improved efficiency in databases including index creation, re-indexing, updating statistics using SQL Profiler. Re-compiling stored Procedures and adding scheduled jobs to re-index and update statistics in databases.• Configured and managed high availability and disaster recovery options. • Configured Availability Groups (AG), Transactional Replication and Fail over cluster.• Supported database creation, backups/restore/recovery, user/schema creation, SQL Server agent jobs and space management. • Created / modified SSIS packages as per business requirements. Migrated SSIS Packages to new AD service.• Modified SSAS cubes.• Created/modified SSRS reports. Also migrated SSIS reports to new AD server.• Created Power BI reports using PostgreSQL/Smartsheet/SQL Server/Snowflake.• Optimized the Aurora PostgreSQL usage and helped reduce costs. Show less

Bellevue, Washington, United States

• Manage database instances in AWS.• Installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting.• Configure and manage availability group.• Trouble shooting and fine-tuning of databases for its performance. • Verified query plans and gave suggestions for performance improvement.• Optimized code and improved efficiency in databases including index creation, re-indexing, updating statistics using SQL Profiler. Re-compiling stored Procedures and… Show more • Manage database instances in AWS.• Installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting.• Configure and manage availability group.• Trouble shooting and fine-tuning of databases for its performance. • Verified query plans and gave suggestions for performance improvement.• Optimized code and improved efficiency in databases including index creation, re-indexing, updating statistics using SQL Profiler. Re-compiling stored Procedures and adding scheduled jobs to re-index and update statistics in databases.• Creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers (DDL & DML) to facilitate efficient data manipulation and data consistency.• Manage OLTP/OLAP databases and handle the ETL processes. • Support database creation, backups/recovery, user/schema creation, SQL Server agent jobs and space management. • Add/modify existing SSIS packages in SQL Server Integration Services (SSIS) / ETL which load data from production database (SQL Server/Postgresql) to data warehouse.• Create/Modify and fix the databases jobs. • Create or modify existing SSRS reports.• Encrypt the databases and install certificate in all servers.• Work on help desk ticket which created by any team for database support (Database Access to database unavailability/ETL data)• Create Power BI /SSRS reports using Snowflake/SQL Server.• Familiarity with Python, C#, Delphi and other object-oriented programming languages.• Familiarity with Fivetran. Show less

Bellevue, Washington, United States

• Support Microsoft Azure customers to resolve critical and complex technical issues leveraging my technical knowledge.• Do root cause analysis for issues and communicate back to customer by collecting relevant facts and investigating the problem.• Collaborate with other teams while performing as a primary technical resource for support and complaint investigation activities.• Empower customers to find information and trouble shoot issues at their end.• Document technical… Show more • Support Microsoft Azure customers to resolve critical and complex technical issues leveraging my technical knowledge.• Do root cause analysis for issues and communicate back to customer by collecting relevant facts and investigating the problem.• Collaborate with other teams while performing as a primary technical resource for support and complaint investigation activities.• Empower customers to find information and trouble shoot issues at their end.• Document technical aspects and research to help trouble shoot issues faster and educate team.. Providing solution to customer based on the data getting retrieved using Kusto queries. Show less

India

Worked as a MS SQL server Developer / DBA and involved in database designing, development, administration, performance tuning, and business intelligence and reporting using MS SQL Server, Oracle, Teradata, Sybase, DB2. Also worked on Installing, configuring, upgrading and managing of SQL Server. Some of my key roles and responsibilities were, designed and implemented comprehensive Backup plan and disaster recovery strategies. Implemented SQL Logins, Roles and Authentication Modes as a part… Show more Worked as a MS SQL server Developer / DBA and involved in database designing, development, administration, performance tuning, and business intelligence and reporting using MS SQL Server, Oracle, Teradata, Sybase, DB2. Also worked on Installing, configuring, upgrading and managing of SQL Server. Some of my key roles and responsibilities were, designed and implemented comprehensive Backup plan and disaster recovery strategies. Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Trouble shooting and fine-tuning of databases for its performance. Verified query plans and gave suggestions for performance improvement. Optimized code and improved efficiency in databases including index creation, re-indexing, updating statistics using SQL Profiler. Re-compiling stored Procedures and adding scheduled jobs to re-index and update statistics in databases. Optimized and Automated SQL Server Administration Tasks like Configuring SQL Mail, Optimizing SQL Server Agent, Managing Operators, Managing all maintenance Jobs and Deploying DTS Packages. Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and Index Tuning Wizards. Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility. Worked on Clustering, Replication, Log Shipping and Database Mirroring. Created ETL Process Consisting of SSIS Packages, Stored procedures and SQL Agent jobs. Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats. Spreading huge tables to different file groups to achieve maximum performance. Query tuning based on High CPU, Memory and Logical reads and writes. Supporting Huge Databases, Troubleshooting the problems. Show less

Thiruvananthapuram Area, India

Worked as SQL server developer and involved in database designing, creation of numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key). Also worked on creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers (DDL & DML) to facilitate efficient data manipulation and data consistency. Some of other responsibilities involved Query analysis, tuning, performance… Show more Worked as SQL server developer and involved in database designing, creation of numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key). Also worked on creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers (DDL & DML) to facilitate efficient data manipulation and data consistency. Some of other responsibilities involved Query analysis, tuning, performance monitoring/troubleshooting using SQL Profiler and DMV's, execution plans review, index coverage and SQL server statistics analysis.Also had exposure working on XML parsing and interfacing with T-SQL. Used TFS (Team Foundation Server) for source code maintenance. Involved in manual testing, Unit testing, Integration testing and System testing.Also played the role of a mentor in MS SQL Server for my team mates. Helped in recruiting SQL resources for the project and also given KT and guidance in SQL functionalities. Show less

Kochi, India

Involved in application development and coding using Delphi 5 and MS SQL server. Some of my key roles and responsibilities were, optimized the performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary with Profiler and Execution Plans. Also developed complex stored procedures, queries, triggers, tables, user functions and views. Involved in… Show more Involved in application development and coding using Delphi 5 and MS SQL server. Some of my key roles and responsibilities were, optimized the performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary with Profiler and Execution Plans. Also developed complex stored procedures, queries, triggers, tables, user functions and views. Involved in Installing, configuring, upgrading and managing of SQL Server. Designed and implemented comprehensive Backup plan and disaster recovery strategies. Created reports using Fast Reports and also created DTS packages. Prepared Test Cases & did unit testing and also involved in go live activities. Show less

Master'S Degree, Computer Science

Bachelor'S Degree, Physics

Pre Degree, Physics

Sslc