Database Mirroring Jobs

Project required to work upon1. Split the one big SQL DB into multiple smaller DB and maintaining the entity sanctity2. SQL Scripting and versioning process to the release3. Migrate East DB data to west DB and eliminate east DB4. Once DB is split migrate data to MongoDB (This would also require Dev team involvement)Required SkillsStrong experience with MS SQL Server - T-SQLExperience with data modelling, database design principlesAbility to write and execute complex SQL scripts for data manipulation, querying, and reporting.Knowledge of CI/CD pipelines for databases using tools like Git or equivalentAnalyse database landscapes to identify migration challenges, risks, and opportunities, translating these into technical specifications and migration plans.Collaborate closely with cross-functional teams to ensure alignment of proposed migration solutions with technical capabilities and product roadmaps.Prepare comprehensive technical documentation, migration plans, and proposals, articulating migration strategies, methodologies, and expected outcomes clearly.Stay abreast of the latest trends, tools, and best practices in database migration, ensuring the proposed solutions incorporate cutting-edge methodologies and technologies.Planning and executing data migration projects, including moving data from existing systems to DB like Mongo DB.Soft Skills:Strong analytical and problem-solving abilities.Effective communication and documentation skills.Ability to speak to various stakeholders/Team like Dev Team, DBA, Solution architects, business analyst etc.Leadership and mentorship qualities.

1. Review & Analyze billing data to identify trends & areas of for improvements.2. Collaborate with other departments, such as finance and customer service to ensure smooth & efficient billing operations.3. Respond to billing inquiries & resolve billing issues as needed.4. To regulate the planning o building construction as per Town/Master Plans/MAP & also passing the blue prints of plans of Town Planning/Master Plans.5. Matter relating to town for proper plan & land use, also to prepare proper transport plans, planning for bus terminal, parking place etc.6. This includes sending involves & account updates to clients, receiving, sorting & tracking incoming payments, addressing & resolving clients questions & issues relating to invoices & providing regular, accurate reports of billing areas.

Job descriptionTo ensure Preventive Maintenance adherence at plantPlant Maintenance/ Machine Shop MaintenanceSpare part Management Planning, Procurement, Spare & Inventory cost controlCritical Spare planningQualification - BE/B.Tech Mechanical (Full Time)Required Candidate profileMean Time to Repair (MTTR) & Mean Time Between Failure (MTBF)Lean Manufacturing : TPM Zero leakage at Shop floor and 5SHydraulic Pneumatics maintenanceJob Title Joint Manager/ManagerReports to Maintenance HeadLocation Savli , VadodaraQualifications &ExperienceBE Mechanical (Full Time) with 13-15 plus years experienceSatish Kohli

Roles and Responsibilities1. Good understanding of SQL Server Architecture, Memory handling.2. Strong knowledge and hands on expertise in below areas:SQL server stored procedures(a) Functions(b) Triggers(c) SQL jobs(d) Performance tuning(e) Writing and reviewing T-SQL code.3. Day-to-Day Production DB support and maintenance of MS SQL server.4. Perform Database system optimization and improvement and query optimization.5. Plan and maintain Database Archiving6. Assisting Application team in detecting performance problems.7. Basic understanding of database development cycle8. Backup and recovery from Backup.9. Knowledge of database index management, statistics update.10. Should be hands-on in writing SQL queriesDesired Candidate ProfileGood to have Hands on experience on Database Mirroring, Log Shipping, Replication and Always-on in all SQL versions