It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Might be available
(Updated 2023-12-07)SQL server| DBA | Architecture | Manager
Ahmedabad, Gujarat, India
Native English, Beginner Norwegian
- 5+ years of experience in handling open source PHP projects as manager
- 10+ years of experience in SQL Server
- 5+ Years of experience in complex project and people management
Skills (34)
MAINTENANCE
DOCUMENTATION
SQL SERVER 2008
MS SQL Server
SQL Server
SQL
DATABASE
REQUIREMENTS GATHERING
TECHNICAL DOCUMENTATION
Database Design
PROCESS IMPROVEMENTS
TEAM PLAYER
DATA SERVICES
MySQL
sql server 2012,16,19,22
PostgreSQL
ACROBAT
Recovery Planning
Data Migration
BI
QA
OPERATIONS
Postgres
MAPPING
Hadoop
Business Intelligence
DATA MODELS
FORECASTING
DATABASE MODELING
ADO
TOPO
BUSINESS REQUIREMENTS
DATA MODELING
Professional Experience
Data Architecture / Senior database developer / IT Manager
MG Marketsoft - Subsidiary of Danish
2012-09 - Present
company Softinform ApS www.softinform.dk) Data Architecture / Senior database developer / IT Manager Sep 2012 - Till date (Over 10 years and 8 months) Technical Experience: ● Worked as Database/SQL/BI/DW/ETL Technical Architect, Design Specialist, Technology Lead and Developer ● Have gained architectural, designing, and hands-on development experience with Microsoft suit, including MS SQL
Senior software engineer
2011-04 - 2022-09
(Over 1 year and 6 months) Technical, Leadership & Management Experience: ● Completely gathered & analyzed the Legacy systems and identified the problems.
● Actively participated in Structured Analysis and Structured Design sessions of the Projects.
● Developed and implemented different User Controls to provide rich user interface reusability.
● Created databases in SQL Server 2008 for different projects and normalized it to the 3 tires.
● Use of advanced concepts like CTEs, CROSS APPLY, PIVOT and Ranking Functions.
● Have worked with SQL in doing database operations. Used SQL extensively for performing database operations.
● Great communication and rapport with other QA engineers, developers, and management ● Developed Standard, Summary, Listing, Cross and Drill down reports and Dynamic Reports using PDF Reports.
● Interacted with the end users to get the new requirements for the reports and testing.
● Provided the Technical Documentation for User manuals, Training plans, and Installation guide.
Organization and Role Synopsis:
● Actively participated in Structured Analysis and Structured Design sessions of the Projects.
● Developed and implemented different User Controls to provide rich user interface reusability.
● Created databases in SQL Server 2008 for different projects and normalized it to the 3 tires.
● Use of advanced concepts like CTEs, CROSS APPLY, PIVOT and Ranking Functions.
● Have worked with SQL in doing database operations. Used SQL extensively for performing database operations.
● Great communication and rapport with other QA engineers, developers, and management ● Developed Standard, Summary, Listing, Cross and Drill down reports and Dynamic Reports using PDF Reports.
● Interacted with the end users to get the new requirements for the reports and testing.
● Provided the Technical Documentation for User manuals, Training plans, and Installation guide.
Organization and Role Synopsis:
Software engineer
Accusol Technologies Pvt. Ltd
2009-03 - 2020-11
(Over 2 years and 1 month) Technical, Leadership & Management Experience: ● Team player activities, Analysis, Designing, Development, Testing ● Requirements Gathering, Analysis source to target mapping.
● Database design and development.
● Implementation Strategy & program flow ● Post-development defect fixing and enhancements.
● Database design and development.
● Implementation Strategy & program flow ● Post-development defect fixing and enhancements.
DBA
2000-01 - 2005-01
Data Warehousing, Entity Relationship (ER) Modeling, Conceptual, Physical, Logical data models, ER/Studio, MS Visio.
● Engaged in various DBA tasks including management and maintenance of databases and servers, performance optimization, backup and recovery processes, security implementation, issue troubleshooting, data migration, disaster recovery planning, capacity forecasting, documentation, and reporting, and conducting trainings.
● Gained knowledge on other technologies like MySQL, Python, Big Data Concepts, Hadoop, Hive, Sqoop, MicroStrategy, R Programming.
● Supported Tools: SVN, GIT, VSS, Visual Studio (SSDT), JIRA, Confluence, Monday, Mantis, Postman.
● Gained end-to-end comprehensive experience & involvement in all phases of projects like business interaction, requirements gathering/analysis, architecture, designing, development, optimization, testing, deployment, enhancements, maintenance, and post-production support experience.
● Prepared & implemented specialized designs for Database, Data Warehouse, Data Modeling, ETL & Reporting designs for specific business purposes.
● Designed & implemented many ETL frameworks end to end.
● Recommended changes on based of data history and tests.
● Created many flow charts, system design diagrams and design documentation to assist problem analysis.
● Automated processes including database server builds, script execution, production requests.
● Review the existing environments and come up with changes that improve the performance, meet SLAs, minimize downtime, are cost effective, adhere to the regulations, and enhance user experience.
Leadership & Management Experience: ● Led Database developer & Data Services teams (including Databases, Data Warehouses, ETL, Reporting), of max 4 members, with overall delivery, quality & client relationship responsibilities for multiple projects & teams at a time.
● Used Agile (Scrum) as well as Waterfall methodologies for software development life cycle (SDLC).
● Worked as a third-party contractor and as vendor; experience dealing at both levels, such as experience with both sending RFPs (RFX) and responding to RFPs with proposals.
● Technical presentations / capability showcases to various prospective clients to clients, at client site and at office, understanding their needs and providing viable solutions and recommendations.
● Established and maintained client and vendor relationships.
● Identified and implemented process improvements across all areas.
● Ensured high customer satisfaction for both delivery and support functions while adhering to defined processes and standards.
● End to end project deliveries, right from project initiation up to project delivery and afterwards support and maintenance functions.
● Excellent project/people management, communication, presentation, and interpersonal skills.
● Possess experience in spearheading several project teams, overseeing aspects such as design, development, maintenance, testing, and providing support.
Organization and Role Synopsis: Sparsh Technologies - Also known as Tatvasoft Technologies (A CMMI Level-3 company www.tatvasoft.com)
● Engaged in various DBA tasks including management and maintenance of databases and servers, performance optimization, backup and recovery processes, security implementation, issue troubleshooting, data migration, disaster recovery planning, capacity forecasting, documentation, and reporting, and conducting trainings.
● Gained knowledge on other technologies like MySQL, Python, Big Data Concepts, Hadoop, Hive, Sqoop, MicroStrategy, R Programming.
● Supported Tools: SVN, GIT, VSS, Visual Studio (SSDT), JIRA, Confluence, Monday, Mantis, Postman.
● Gained end-to-end comprehensive experience & involvement in all phases of projects like business interaction, requirements gathering/analysis, architecture, designing, development, optimization, testing, deployment, enhancements, maintenance, and post-production support experience.
● Prepared & implemented specialized designs for Database, Data Warehouse, Data Modeling, ETL & Reporting designs for specific business purposes.
● Designed & implemented many ETL frameworks end to end.
● Recommended changes on based of data history and tests.
● Created many flow charts, system design diagrams and design documentation to assist problem analysis.
● Automated processes including database server builds, script execution, production requests.
● Review the existing environments and come up with changes that improve the performance, meet SLAs, minimize downtime, are cost effective, adhere to the regulations, and enhance user experience.
Leadership & Management Experience: ● Led Database developer & Data Services teams (including Databases, Data Warehouses, ETL, Reporting), of max 4 members, with overall delivery, quality & client relationship responsibilities for multiple projects & teams at a time.
● Used Agile (Scrum) as well as Waterfall methodologies for software development life cycle (SDLC).
● Worked as a third-party contractor and as vendor; experience dealing at both levels, such as experience with both sending RFPs (RFX) and responding to RFPs with proposals.
● Technical presentations / capability showcases to various prospective clients to clients, at client site and at office, understanding their needs and providing viable solutions and recommendations.
● Established and maintained client and vendor relationships.
● Identified and implemented process improvements across all areas.
● Ensured high customer satisfaction for both delivery and support functions while adhering to defined processes and standards.
● End to end project deliveries, right from project initiation up to project delivery and afterwards support and maintenance functions.
● Excellent project/people management, communication, presentation, and interpersonal skills.
● Possess experience in spearheading several project teams, overseeing aspects such as design, development, maintenance, testing, and providing support.
Organization and Role Synopsis: Sparsh Technologies - Also known as Tatvasoft Technologies (A CMMI Level-3 company www.tatvasoft.com)
Academic Background
MCA
Sardar Patel University
2024-10 - 2024-10
Bachelor of Computer Applications
Sardar Patel University
2008-01 - 2008-01
Certifications
Microsoft AZ-900 Azure fundamentals, DP-900 Azure data fundamentals certification.