14 years of experience in database designing, development, administration, performance tuning, business intelligence, reporting and testing using MS SQL Server (On-prem/Azure/AWS), Oracle, Teradata, Sybase, DB2, Snowflake, MySQL and PostgreSQL.MS SQL Server (Versions: 2000, 2005, 2008, 2012, 2014, 2017, 2019).Expertise in Stored procedures, Functions, Triggers, Indexes, User-defined functions, Common Table Expressions (CTE) and Views.Expertise in SQL Profiler, Performance Monitor, Performance Tuning, Query Optimization, Dynamic Management Views (DMV), Tuning advisor and Database Consistency Checks. Expertise in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting.Experience in Clustering, Always-On, Replication, Log Shipping and Database Mirroring.Experience in database creation, backups/recovery, user/schema creation, SQL Server agent jobs and space management. Experience in DTS and SQL Server Integration Services (SSIS) / ETL technologies.Knowledge in building data cubes by implementing SQL Server OLAP services in SSAS, Microsoft Power BI. Knowledge in SSAS tabular model with partitions, created measures using DAX functions, MDX.Good understanding of data warehousing, dimensional data modeling and schemas such as star, snowflake schema. Good knowledge of entity relationship diagram (ERD) and data modelling.Knowledge on all types of report types like tables, matrix, charts, sub reports, Dashboards, Linked Reports, Drilldown, Drill through, Matrix Parameterized reports etc. Expertise in Microsoft Azure SQL PaaS, Azure SQL (IAAS), Azure data factory.Expertise in Kusto queries.Teradata,OracleExperience in database designing, creating views and writing SQL queries.Experience in creating reports using advanced techniques like rank, row number.Experience in PL-SQL creating stored procedures, functions and packages.Expertise in Delphi Expertise in Snowflake. Knowledge in Copilot, Azure OpenAI.Expertise in PostgreSQL, Cosmos and MySQL databases.Expertise in collaborating with teams to test and deploy modules to production.Expertise in creating user stories, tasks and bug tickets. Expertise in documenting business, technical and functional analysis and database best practices.Exposure in working closely with the design team in creating mockups, wireframes and workflows.Expertise in report generation using Crystal Reports and Fast Reports.Experience in version controlling tools like TFS, VSS and GIT.Expertise in PowerShell.Knowledge in Python.
-
Database Administrator And Database DeveloperTacoma Community College Sep 2024 - PresentTacoma, Washington, United States -
Database DeveloperDeloitte Jul 2024 - Present -
Dba/Dbe- Level 3Zones, Llc Aug 2022 - May 2024Auburn, 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 -
Dba/DbeEagleview Apr 2021 - Aug 2022Bellevue, 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 -
Senior EngineerMindtree Jul 2020 - Apr 2021Bellevue, 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 -
Sr Sql Developer/Dba/Teradata Developer (Team Lead)Ibm Oct 2010 - Jul 2015IndiaWorked 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 -
Sql Server/Delphi /.Net DeveloperGemini Software Solutions Pvt. Ltd. May 2007 - Oct 2010Thiruvananthapuram Area, IndiaWorked 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 -
Sql Server/Delphi DeveloperGeojit Technologies Oct 2005 - Apr 2007Kochi, IndiaInvolved 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
Cini Thomas Education Details
-
Sree Amman Arts And Science CollegeComputer Science -
Govt High School Thumpamon NorthSslc
Frequently Asked Questions about Cini Thomas
What company does Cini Thomas work for?
Cini Thomas works for Tacoma Community College
What is Cini Thomas's role at the current company?
Cini Thomas's current role is Database Engineer.
What schools did Cini Thomas attend?
Cini Thomas attended Sree Amman Arts And Science College, Catholicate College, Pathanamthitta - 689 645, Catholicate College, Pathanamthitta - 689 645, Govt High School Thumpamon North.
Not the Cini Thomas you were looking for?
-
2gmail.com, att.com -
Cini Thomas
Greater Melbourne Area -
Cini Thomas
Global Sales Manager | Business Development Manager | Aviation Hr | Aviation Professional | Private CharterDubai, United Arab Emirates3gmail.com, safiairways.com, titanaviation.co.in2 +130540XXXXX
-
1hotmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial