My Belief: you cannot remember everything, but with the experience and analytical skills, you can solve anything. A good team player and friendly in nature. Balanced life between Work, Technology & hobbies. I like to play with queries and solve a complex problem. Result oriented. Love to solve performance issues.
Experience
I have 5 years of experience working as a SQL Server Database Developer/Administrator in the private limited company. Samyak Infotech Private Ltd. Senior SQL Server Developer cum Administrator | Ahmedabad, GJ, India | Jan 2015 - Dec 2019 • Developing for very large and complex databases in SQL Server 2016, 2014, 2012, SQL Server 2008 R2, 2008, and 2005. • Experienced with SQL Server installation and configuration (Server Migration). • Expertise in Database Developing on Production Server/Test servers, performance tuning, monitoring, and maintenance with troubleshooting capabilities, coding Stored Procedures, T-SQL, Tables, Triggers, Functions, Views. • Hands-on experience of Data Migration (SQL to SQL, MySQL to SQL with Heidi SQL) on Local and production environments. • Test and validate data to ensure successful data migration and conversion. • Database schema creation and management. • Work closely with teams, leads, partners for the different developing requirements. • Experienced with backups, restores, and recovery models. • Experienced with user management, roles, and assign permission. • Can perform Replication, Mirroring, and Ship transaction log. • Refine and automate regular processes, track issues, and documentation. • Log files analysis. (Trace flag setting) & Experienced to analyze execution plans and lookup solving. • Experience in Index analysis, creation, and modification (Rebuild/Reorganize). • Experienced with Profiler tracing to identify/solve the problem (deadlock/query time out issues). • Expertise in SQL job creation (SQL Server Agent). • Alert /Notification creation. • Extracting, Transforming, and Loading (ETL) Data using scripts, import/export data, SSIS Packages, and bulk insert. • Knowledge to connect DB with command prompt and execute SQL Queries and basic operations. • Report Design/Creation/Deployment/Configuration with SSRS. • Experienced to create Packages in SSIS. • Experienced to handle MySQL DB. (Basic developing). • TFS handling. • Familiar with POWER BI Desktop, Cube design using SSAS & Python basics. • Ability to work in a rapidly changing environment. • Ability to do multi-task and context-switch effectively between different activities and teams.
Projects
Logistics shipping & Inventory Management (USA Project & Client): MVC framework & AngularJS, SQL Server 2012 for the Database, SSRS for the Reporting services (BI), SSIS for integration. The project was containing several modules like Operations, Inventory, Billing, Itinerary, Order Processing, Rate, Admin, etc. Basically, the project was about to ship customer’s packages or parts from source to destination either it could be a ground delivery or via Air delivery based on a mileage calculation. It was included different stages up to Delivery, etc. To sum up, it was with so many major and minor functionalities to accomplish the customer’s requirement. As a DBA, I was part of all modules. Developing, Analysis, Designing, Modification, monitoring & maintaining performance, creating & deployment of the reports (Local & production servers), Data & Server Migration. Responsibilities: • Experienced working with Development & QA team. • Migrated large scale data from the legacy system to the current system on a development & production environment. Provided production support. (Client requirement). • Server Migration (Lower to Higher): Analyzed dependencies & Closing / new functionalities, Documentation for all the challenges, Worked with team for the Migration. • Rate setup & testing. • Logistic Alexa skills – DB changes and procedures created by me. (Example: current status, tracking). • Experienced to perform Import/Export, Bulk Insert, Extract data from XML format, working with SSIS packages. • Handled database creation, development, and management including data dictionary, normalization, large & complex procedure creation, and modification, reports, functions, views, cursor creation (scripts), triggers, indexing, and performance, etc. • Solved performance issues related to long time running queries/procedures. • Solved fragmentation and space issues, query timing issues with index creation & modification, index rebuild, and reorganization. • Aware with system queries. • Solved query/deadlock issues based on log files & profiler tracing. • Installed and Configured SQL Server, Management Studio, and Setup instances. • Handled Backup & restore. • Scheduled Jobs with SQL Server Agent. (Development & Production environment). • Responsible for user creation, assign appropriate roles and permissions. • Configured Database mail as per requirement. • Configured SSRS, Development, designing, testing, and deployment of reports on local to production server. (Servers: Local+ QA + DEV + STG + Pre-Prod + Prod). • Created Dashboard reports. • Provided on-time solutions and support to the team who associated with industrial, law, and space-related projects. • Independently worked on smaller projects. (Fully DB side).
AESHA RAJENDRAKUMAR PANCHAL has not posted anything yet