| Candidate Information | | Title | Sql Database Administrator | | Target Location | US-NJ-Pennington |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateAccomplished SQL database developer and SQL database administrator professional with 15 years of IT industry experience in developing, testing, and maintaining databases and data warehouses. Proficient in SQL programming, ETL processes, BI tools such as Tableau and Power BI and Data modeling tool ERWIN. Strong analytical skills combined with the ability to translate complex data into actionable insights for decision-making. Multi-skilled and extensive hands-on expertise in areas like Developing, testing, Implementation, T-SQL writing Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions, Cursors, Backup, Restore, and Exposure on Mirroring, Clustering, log shipping. Have managed large data lead global engagements leading digital transformation, product transformation, and service management for MNC clients.Core competencies include sound delivery / technical background, people, and quality management skills. Experienced in building software/product development, troubleshooting performance problems, fine-tuning databases, and index Analysis. Experienced SQL Developer proficient in accessing data via APIs utilizing tools like Postman. Skilled in seamlessly integrating external data sources into internal systems, ensuring data accuracy and reliability. Have experience in leveraging cloud technologies, particularly Google Cloud Platform (GCP), to enhance data management and analytics capabilities. Proficient in deploying, managing, and optimizing cloud-based solutions to meet diverse business needs. Skilled in utilizing GCP services such as Big Query, Dataflow, and Pub/Sub for scalable data processing and analysis.Technology & R & DBusiness IntelligenceETL developmentDelivery ManagementService redesign/deliveryProduction managementshell scriptingDatabase ManagementProject ManagementData modeling tool ERWINClient Relationship ManagementPower BIExperience HistorySimple Solve Inc.Pennington, USASenior ConsultantAug 2023 to till dateTata Consultancy Service LtdChennai, IndiaProject ManagerSep 2020 Aug 2023Sankara Nethralaya Medical Research FoundationChennai, IndiaTeam LeadFeb 2009 - June 2010My professional experience includes working with Global companies and managing their IT services portfolio and product development from globally distributed locations and consistently providing customer delight.Key accomplishments12+ years of experience in Database Development and Administrator in SQL Server various versions like 2000, 2005, 2008, R2, 2012, 2014, 2016, and SQL Server 2017.Defined the complete data warehouse architecture (e.g. ODS, ETL process, Data Marts, EDW, RTS).Review, design, and develop data models, data mappings, and stored procedures with technical leaders and developers in support of ETL processes and software product needs.Troubleshoot performance problems, fine-tuning databases, and index Analysis.Expert at basic and advanced report creation (table, chart, matrix report, web reporting) along with excellent experience in report serving architecture.Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.Develop, test, and implement performance and resource optimization initiatives in consultation with development teams.Excellent experience in developing complex stored procedures, efficient triggers, required functions, creating indexes, and indexed views for improving performance.Expertise in Database Administration on Production Servers with server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities.Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.Expertise in T-SQL writing stored procedures, triggers, and functions.Administering SQL Server High Availability and Disaster Recovery strategies.Experience in using DMV and dynamic management functions for finding out long-running queries.Experience in Disaster Recovery Planning and Security Management operations, and set up Log Shipping, Database Mirroring and Replication, and MSSQL Mail.Set up security and access profiles and procedures for database system administrators.Suggested, developed & implemented Scaling out solution with Data partitioning.Suggested Application level tuning changes for code, queries, and SQL objects which may not be performing up to the optimum database performance standards.Monitored the database server performance and if required go for tuning of the TSQL queries, Stored Procedures etc.Assessed new and changed requirements and determined their impact on existing ETL routines.Implemented the best practices and guidelines for Data Integration and Data Migration services.Tools / SkillsOperating PlatformsWindowsDatabasesSQL Server, Snowflake, MYSQL, ETL with SQLProgramming LanguagesAsp.net, Java scriptBig Data EcosystemsHadoop, HDFS, HBase, Zookeeper, Hive, Pig, SqoopMajor Project Engagements:Project Description 1SimpleINSPIRE, a fully integrated Platform, is designed to meet the challenges of unprecedented transformation in the Insurance industry and take advantage of disruptive technologies, and digital abundance. Policy Management system is a platform with a visionary architecture and a foundation built on disruptive technologies for digital-first enablement. It empowers you to drive change rather than be driven by change. Introduce new norm policy products with confidence. The platform has an integrated insurance claims system to create and manage claims. A claim can have multiple claims features to manage multiple claims arising out of a single incident. Managing and reporting claims can be done at the Claim level or the Feature level. The SimpleINSPIRE Insurance Claims system can create letter templates to generate claims-related correspondence providing operational efficiency.Responsibility :Working on SQL server development, SQL database administrator, Snowflake SQL, and Snowflake pipeline.Proficient in Extract, Transform, Load (ETL) processes, with expertise in designing, developing, and optimizing data workflows.Managing, troubleshooting, and resolving database and application-related issuesExperienced in using ETL tools and technologies such as Oracle Data Integrator, Informatica, and Talend to ensure the integrity and reliability of data pipelines.Used COPY to bulk-load the data.Production Database Administrations.Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors, and procures/views in Snowflake.Skilled in utilizing GCP services such as Compute Engine, BigQuery, Dataflow, Pub/Sub, and others to build scalable and resilient cloud architectures.Checking of Cluster availability for Data Base serversInstallation of database server software.Creating user IDs and defining roles, allocating quotas with necessary privileges for all databases.Gathered requirements and Created data models for the databases.Normalized data model for optimum performance.Designed and Implemented Backup and Recovery Strategies and took backup using scripts.Defining and Setting backup and recovery proceduresDeveloping backup scripts to automate the backup procedures.Tuning and balancing I/O by monitoring file system and table space I/O statistics.Re-indexing periodicallySQL and PL/SQL ProgrammingProject Description 2Electronic Medical Records (EMR) - Major functionalities of EMR is a complete Electronic Clinical data of the patients, which is powered with various modules like Appointment List, IPEMR, OPEMR and Clinical Procedures & Tests. The application is tightly integrated with main modules of HMS like Appointment and surgeryResponsibility :Working along with programmers and contributing to the development team process.Managing, troubleshooting and resolving database and application related issuesProduction Database Administrations.Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors.Checking of Cluster availability for Data Base serversInstallation of database server software.Creating user ids and defining roles, allocating quotas with necessary privileges for all databases.Gathered requirement and Created data model for the databases.Normalized data model for optimum performance.Designed and Implemented of Backup and Recovery Strategies and taken backup using scripts.Defining and Setting backup and recovery proceduresDeveloping backup scripts to automate the backup procedures.Tuning and balancing I/O by monitoring file system and table space I/O statistics.Re indexing periodicallySQL and PL/SQL ProgrammingProject Description 3Hospital Management System (HMS) Sankara Nethralaya is one of the worlds best ophthalmic care and research centers, which serves around 2000 patients a day. The center houses around thirty various departments, which efficiently manage patient care and medical services. The major functionalities of HMS is a fully integrated Hospital Management suit that is powered with various applications like Appointment Scheduling, Patient Registration, Billing, Clinical laboratories, Wards, Surgery Scheduling, Purchase, Pharmacy, and Stores.Responsibility:Developing backup scripts to automate the backup procedures.Managing, troubleshooting, and resolving database and application-related issues.Developed SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors.Installation of database server software.Creating users, allocating quotas with necessary privileges and roles for all databasesDeveloping backup scripts to automate the backup procedures.Tuning and balancing I/O by monitoring file system and table space I/O statistics.Re-indexing periodicallyProject Description 4Medical Records Management SystemMajor functionalities of the MRD project involve the maintenance of Surgery details, Doctor Details, and Operation Theatre details.Responsibility:Developing backup scripts to automate the backup procedures.Designing the MRD System.Programming the application.Testing.Integrating with other modules of the HPMS.Generating reports.Developed SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors.Installation of database server software.EDUCATION, RECOGNITIONS & AWARDSAcademics Master of Computer Application 2007Academics Bachelor of Science 2004 |
