SQL Database Optimization Specialist – Contract Position We are looking for an expert-level SQL Database Optimization Specialist to analyze, optimize, and automate database performance for our Front Arena trading platform . The ideal candidate will have deep expertise in SQL performance tuning, indexing strategies, database automation, and storage optimization to enhance system efficiency and ensure long-term sustainability. Key Responsibilities 1. Database Performance Tuning & Optimization Indexing & Re-indexing: Implement re-indexing, index optimization, and fragmentation management for efficient database performance. Query Optimization: Analyze and fine-tune queries to reduce latency and enhance performance . Transaction Log Management: Optimize and restructure transaction log files for efficient database operation. Automation of Maintenance Tasks: Develop automated scripts to trigger index maintenance, re-indexing, and database optimization after every Front Arena upgrade. 2. Database Size Reduction & Storage Optimization Current DB Size: 1TB (720GB actual data, 180GB transaction logs). Optimization Strategy: Implement a single 50GB data file with 2GB auto-growth , saving up to 130GB per database . Re-indexing Strategy: Reduce database size by at least 100GB by optimizing indexing structures. Index Fragmentation Monitoring: Identify and fix fragmented indexes after data deletions to maintain system health. 3. Automation & Continuous Monitoring Automated Indexing Analysis: Implement automation to track active vs. unused indexes and suggest optimizations. Missing Index Recommendations: Identify and implement missing indexes that improve query execution time . Performance Monitoring Tools: Utilize SQL tools to monitor index usage, query execution plans, and storage trends . 4. Collaboration & Stakeholder Engagement Work closely with Front Arena Core Team & FIS Team to align database optimization strategies. Coordinate with application teams to ensure database performance supports trading operations. Provide recommendations for database infrastructure improvements . Required Skills & Experience ✅ 10+ years of experience in SQL Database Administration & Optimization . ✅ 5+ years of hands-on experience in indexing, re-indexing, and fragmentation management . ✅ Expertise in SQL Server performance tuning, indexing strategies, and database optimization . ✅ Strong knowledge of SQL Server internals, transaction logs, and query execution plans . ✅ Experience working with large-scale databases (1TB+ size) in high-performance environments . ✅ Experience in automation of SQL performance tuning and index management . ✅ Proficiency in SQL performance monitoring tools & automation scripts . ✅ Preferred: Experience with financial or trading platforms (e.g., Front Arena) Contract Position - 1 Year Location: Hyderabad Salary: upto 20-LPA For more details contact Ravi - 6301197531 Job Types: Full-time, Permanent Pay: ₹1,500,000.00 - ₹2,000,000.00 per year Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Work Location: In person
Hi Everyone We are looking the below requirement Position: Sr. Sales Manager Location: Puducherry Experience: 3 to 4 years in Business Loan Interested candidates please send your resume to sravanthi.b@thehirewings.com Job Types: Full-time, Permanent Pay: ₹20,000.00 - ₹40,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Experience: Business Loan: 2 years (Required) Work Location: In person
Hello Everyone, We are looking for the below requirement: Position: SR. SEO Experience: 4+ Years Location: Hyderabad Skills: SEO, on page, Off page, site audit, website analysis, key word research, link building Interested candidates or references please drop cv: sireesha.r@thehirewings.com/9346429928 Job Types: Full-time, Permanent Pay: ₹25,000.00 - ₹50,000.00 per month Benefits: Food provided Health insurance Provident Fund Schedule: Day shift Fixed shift Supplemental Pay: Performance bonus Experience: Total: 4 years (Required) SEO: 4 years (Required) Location: Hyderabad District, Telangana (Required) Work Location: In person
Hi Everyone, We are looking for the below requirement: Position: Platform Engineer Location: Hyderabad Key Responsibilities: Maintain and enhance platform infrastructure across Linux and Windows environments Develop scripts to automate system monitoring, deployment, and recovery processes Troubleshoot and resolve environment-level issues impacting application performance Build and manage CI/CD pipelines using tools like Jenkins, Azure DevOps, or GitHub Actions Collaborate with development, support, and cloud teams to ensure high platform availability Support and automate tasks like patching, environment readiness, and DR test setups Work with DBAs, application teams, and product vendors to resolve infra-related performance bottlenecks Document processes, create knowledge articles, and ensure knowledge continuity Mandatory Skills: 6-9 years of experience in infrastructure/platform engineering Strong hands-on skills in Windows, Linux , Bash scripting and Powershell Experience with CI/CD pipelines and deployment automation Proficiency in tools such as Ansible, Jenkins, Azure DevOps, Git Experience with log aggregation and monitoring (e.g., ELK, Grafana, Prometheus) Comfortable supporting enterprise-grade applications in a financial services environment Preferred Skills: Exposure to Cloud platforms like AWS (especially EC2, S3, IAM, CloudWatch) Familiarity with application support tools and release pipelines SQL knowledge and ability to work with DB teams for performance tuning Prior experience working with geographically distributed teams Interested candidates or references please drop cv: sireesha.r@thehirewings.com/9346429928 Job Types: Full-time, Permanent Pay: ₹1,000,000.00 - ₹2,800,000.00 per year Benefits: Health insurance Provident Fund Schedule: Day shift Monday to Friday Morning shift Supplemental Pay: Joining bonus Performance bonus Ability to commute/relocate: Hyderabad District, Telangana: Reliably commute or planning to relocate before starting work (Required) Experience: Total: 6 years (Required) PlatForm Engineer/ Devops Engineer: 6 years (Required) Work Location: In person
Profile: Sr.RCM Executive- AR Caller (US Medical Billing Process) Experience: 1+Year Shift Timing: 05:30 PM to 02:30 AM (Monday to Friday) Position Overview: We are seeking a highly motivated and detail-oriented individual to join our team as an Accounts Receivable (AR) Caller in our US Medical Billing Process. The AR Caller will be responsible for managing accounts receivable for medical services rendered, ensuring timely payments from insurance companies, and resolving any discrepancies or denials. Interested candidates please drop cv: sireesha.r@thehirewings.com/9346429928 Job Types: Full-time, Permanent Pay: ₹15,000.00 - ₹40,000.00 per month Benefits: Health insurance Schedule: Day shift Monday to Friday Night shift US shift Ability to commute/relocate: Ahmedabad, Gujarat: Reliably commute or planning to relocate before starting work (Required) Experience: AR CALLER: 1 year (Required) RCM: 1 year (Required) Denials: 1 year (Required) Language: English (Preferred) Work Location: In person
Hello Everyone, We are looking for the below requirement: Position: HR Statutory Compliance Experience: 1+years Location: Chennai_ work from office Language: Hindi, Tamil and English Skills: HR Compliances, Statutory compliances, pf, Esi, challans, Gratuity, lwf, Labour law, ESIC, ACTS, Wages ETC. Interested candidates or references please drop cv: sireesha.r@thehirewings.com/9346429928 Job Types: Full-time, Permanent Pay: ₹15,000.00 - ₹30,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Weekend availability Supplemental Pay: Commission pay Experience: HR Statutory Compliance: 1 year (Required) PF, ESI, GRATUTITY, LWF,CHALLAN: 1 year (Required) Language: English (Required) Hindi (Required) Tamil (Required) Location: Chennai District, Tamil Nadu (Required) Work Location: In person
Hello Everyone, We are looking for the below requirement: Position: HR Recruiter Location: Hyderabad_ Kondapur Experience: 0.6Months to 2years Skills: End to end recruitment, sourcing, screening, shortlisting, NON -IT Recruitment, Must experience into NON- IT Requirements with different industry. If anyone interest or references, please drop cv: sireesha.r@thehirewings.com/ 9346429928 Job Types: Full-time, Permanent Pay: ₹13,000.00 - ₹20,000.00 per month Benefits: Health insurance Paid sick time Provident Fund Schedule: Day shift Monday to Friday Morning shift Weekend availability Experience: HR Recruitment: 1 year (Required) NON IT Recruitment: 1 year (Required) Location: Hyderabad District, Telangana (Required) Work Location: In person
Job Title: HR Executive Location: T-Nagar-Chennai Experience: 2–3 years Salary: 25,000 - 30,000 Employment Type: Full-time Department: Human Resources Reports To: HR Manager / HR Head Languages: Tamil, English, Hindi (Able to speak - Mandate) Job Summary: We are looking for a dynamic and detail-oriented HR Executive to join our team. The HR Executive will be responsible for supporting various HR functions including recruitment, onboarding, employee engagement, compliance, and administrative tasks to ensure smooth and efficient business operations. Key Responsibilities: Assist in recruitment efforts by sourcing candidates, scheduling interviews, and coordinating with hiring managers. Manage the onboarding and induction process for new employees. Maintain and update employee records (e.g., personal information, attendance, leaves). Support the implementation of HR policies and procedures. Address employee queries regarding HR policies, payroll, benefits, etc. Assist in organizing training & development programs. Taking care employee Entry & Exit formalities Handle administrative tasks related to HR such as documentation, letters, and reports. Support in performance management and employee engagement initiatives. Requirements: Bachelor’s degree in Human Resources, Business Administration, or a related field. 2–3 years of experience in an HR role. Knowledge of HR functions, labor laws, and HR software (e.g., HRMS, payroll systems). Strong communication, interpersonal, and organizational skills. Ability to handle sensitive and confidential information with discretion. Contact: Ravi-6301197531 Job Type: Full-time Pay: ₹25,000.00 - ₹30,000.00 per month Benefits: Health insurance Life insurance Paid sick time Paid time off Provident Fund Schedule: Day shift Fixed shift Morning shift Weekend availability Supplemental Pay: Performance bonus Yearly bonus Language: English (Preferred) Work Location: In person
Job Summary: We are seeking a creative and detail-oriented Junior Architect to join our team. This role is ideal for fresh graduates or professionals with up to 1 year of experience in architecture. You will assist in design development, drafting, and project coordination while gaining practical exposure to architectural projects. Key Responsibilities: Assist in creating architectural designs and construction drawings. Support senior architects in preparing concepts, presentations, and client proposals. Use design software (AutoCAD, SketchUp, Revit, etc.) for drafting and modeling. Coordinate with internal teams and vendors for timely project execution. Ensure compliance with local building codes and regulations. Job Types: Full-time, Permanent, Fresher Pay: ₹10,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Work Location: In person
Job Description: * Manage end-to-end recruitment for assigned roles, including sourcing, screening, interviewing, and closing candidates. *Develop and post job advertisements on various job portals, social media platforms, and the company’s career page. *Proactively source candidates using databases, networking, and employee referrals. *Conduct initial HR interviews and assess candidate suitability in line with job requirements and organizational culture. *Coordinate interview schedules with hiring managers and provide timely follow-up to candidates. *Maintain candidate data and hiring records in the Applicant Tracking System (ATS). *Support onboarding processes for new hires in collaboration with the HR and operations teams. *Collaborate with hiring managers to understand team needs and develop talent acquisition strategies. *Monitor recruitment metrics to improve hiring efficiency and candidate experience. *Stay updated on industry hiring trends and best practices. Job Types: Full-time, Permanent, Fresher Pay: ₹10,000.00 - ₹25,000.00 per month Benefits: Health insurance Life insurance Paid sick time Paid time off Provident Fund Schedule: Day shift Fixed shift Morning shift Weekend availability Education: Bachelor's (Required) Work Location: In person
Job Summary: We are seeking a creative and detail-oriented Junior Architect to join our team. This role is ideal for fresh graduates or professionals with up to 1 year of experience in architecture. You will assist in design development, drafting, and project coordination while gaining practical exposure to architectural projects. Key Responsibilities: Assist in creating architectural designs and construction drawings. Support senior architects in preparing concepts, presentations, and client proposals. Use design software (AutoCAD, SketchUp, Revit, etc.) for drafting and modeling. Coordinate with internal teams and vendors for timely project execution. Ensure compliance with local building codes and regulations. Job Types: Full-time, Permanent, Fresher Pay: ₹10,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Work Location: In person
Position: HR RECRUITER Experience: 0.6 to 2 Years Location: Hyderabad_ Kondapur Gender: Prefer male candidates Skills: end to end recruitment, sourcing, screening, scheduling, interviewing, IT and NON-IT recruitment skills, good communication skills Good experience in portals: Naukri, shine, linked in etc. Interested candidates or references please drop cv: sireesha.r@thehirewings.com/9346429928 Job Types: Full-time, Permanent Pay: ₹13,000.00 - ₹22,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Monday to Friday Work Location: In person
Hi Everyone We are looking the below requirement, Position: Architecture Location: Gachibowli, Hyderabad Experience: Freshers to 2 Years Qualification: Must have B. Arch Skills : Acceptable for fresher, Internship and Freelancing experience Must Experience/Knowledge into AutoCAD, Sketchup, 3DMax, Revit Interested candidates send your resume to [email protected] /8074940756 Job Types: Full-time, Permanent, Fresher Pay: ₹12,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Work Location: In person
Role: Interior Designer Exp: 3+ years Location: Hyderabad Key Responsibilities: Create and deliver compelling client pitch presentations and detailed renderings, including floor plans, elevations, and finish plans. Design customized finishes and furnishings with a focus on sustainability, including the use of reclaimed wood and repurposed materials. Develop innovative, cost-effective, and space-saving solutions tailored to the needs and constraints of each space. Collaborate closely with clients to assess space usage and recommend materials, furnishings, and timelines to meet project goals. Manage several residential interior design projects simultaneously, ensuring each is completed on time, within budget, and to the highest standard. Demonstrate leadership by delegating tasks effectively to the design team and providing follow-up to ensure alignment with client specifications. Oversee all purchasing activities, including vendor negotiations, subcontractor management, and preparation of proposals, contracts, and construction documentation. Maintain outstanding client communication and service from initial contact through final walkthrough, fostering long-term relationships and referrals. Qualifications: Bachelor’s degree in Interior Design or related field preferred Proven experience (3+ years) in residential interior design Proficiency in design software such as AutoCAD, SketchUp, Revit, and Adobe Creative Suite Strong understanding of materials, furnishings, and construction practices Excellent project management and organizational skills Strong interpersonal and communication skills Passion for sustainable and functional design Contact: Ravi-6301197531 Job Types: Full-time, Permanent, Fresher Pay: ₹20,000.00 - ₹30,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Supplemental Pay: Commission pay Performance bonus Yearly bonus Work Location: In person
Hi Everyone We are looking the below requirement, Position: Architecture Location: Gachibowli, Hyderabad Experience: Freshers to 2 Years Qualification: Must have B. Arch Skills : Acceptable for fresher, Internship and Freelancing experience Must Experience/Knowledge into AutoCAD, Sketchup, 3DMax, Revit Interested candidates send your resume to sravanthi.b@thehirewings.com/8074940756 Job Types: Full-time, Permanent, Fresher Pay: ₹12,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Work Location: In person
Role: Interior Designer Exp: 3+ years Location: Hyderabad Key Responsibilities: Create and deliver compelling client pitch presentations and detailed renderings, including floor plans, elevations, and finish plans. Design customized finishes and furnishings with a focus on sustainability, including the use of reclaimed wood and repurposed materials. Develop innovative, cost-effective, and space-saving solutions tailored to the needs and constraints of each space. Collaborate closely with clients to assess space usage and recommend materials, furnishings, and timelines to meet project goals. Manage several residential interior design projects simultaneously, ensuring each is completed on time, within budget, and to the highest standard. Demonstrate leadership by delegating tasks effectively to the design team and providing follow-up to ensure alignment with client specifications. Oversee all purchasing activities, including vendor negotiations, subcontractor management, and preparation of proposals, contracts, and construction documentation. Maintain outstanding client communication and service from initial contact through final walkthrough, fostering long-term relationships and referrals. Qualifications: Bachelor’s degree in Interior Design or related field preferred Proven experience (3+ years) in residential interior design Proficiency in design software such as AutoCAD, SketchUp, Revit, and Adobe Creative Suite Strong understanding of materials, furnishings, and construction practices Excellent project management and organizational skills Strong interpersonal and communication skills Passion for sustainable and functional design Contact: Ravi-6301197531 Job Types: Full-time, Permanent, Fresher Pay: ₹20,000.00 - ₹30,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Morning shift Supplemental Pay: Commission pay Performance bonus Yearly bonus Work Location: In person
Role: Engineer Maintenance Mechanical Exp: 2 - 9 Years Salary: 6 to 14 LPA Job Accountabilities: Execute Mechanical Maintenance tasks with quality Supervise mechanical maintenance tasks to ensure quality and timely completion and as per planning Mobilize resources for day-to-day mechanical maintenance activities Ensure compliance to procedures and best practices Assist respective discipline Manager in Spares identification for procurement Prepare mechanical maintenance budget Analyze Mechanical Maintenance cost and budgeting Prepare audit related documents for manager Conduct regular Troubleshooting and analysis when appointed as a member of RCA team Collate discipline data for performance monitoring and reporting Contractor management Participate in Reliability & Integrity studies as identified Implementation of recommendations Carryout preservation activities as per schedule Identify & interact with Workshop for repair activities Knowledge management activities for self & subordinates as applicable Maintain history/ records Maintain integrity of maintenance SAP-PM and SAP-MM data, analysis and costs - by timely and correct data entries and validations Facilitate and support minor projects activities Supervise and mobilize resources for shut down jobs as per plan Carry out LLF as per plan Ensure that all pending jobs are promptly entered into SAP-PM system Weekly preparation of maintenance KPIs of Mech. Ensure improvement in availability of equipment Timely adherence to audit schedules Ability to Minimize production/ quality loss in event of unplanned failure Ensure compliance of mandatory trainings. Inventory control of Mechanical spares. Ensure Shutdown jobs execution as per schedule. Maintaining IMS documents for Mechanical Maintenance HSEF compliance (RESOP, MIQA, CFA, DOSHE mandatory trainings). Skill & Competencies: Passion to excel Entrepreneurial Mind-set Managing Ambiguity Detail Orientation Lifelong Learning Mech equip - Periodic, Proactive and shutdown maintenance Repair & Refurbishment Troubleshooting & Analysis Turnaround & shutdown coordination Contractor Management Education Required: Diploma/Bachelor's degree in Mechanical/ Production Engineering. Contact: Ravi-6301197531 Job Types: Full-time, Permanent Pay: ₹40,000.00 - ₹100,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Fixed shift Morning shift Work Location: In person
Key Responsibilities: Manage day-to-day accounting operations and entries (Tally/ERP). Handle accounts payable and receivable. Prepare GST, TDS, and other tax filings. Assist in monthly, quarterly, and annual closing processes. Maintain accurate financial records and reports. Reconcile bank statements and oversee cash flow. Coordinate with internal teams and external auditors. Job Types: Full-time, Permanent Pay: ₹15,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Fixed shift Morning shift Supplemental Pay: Performance bonus Quarterly bonus Yearly bonus Application Question(s): Willing to work Head Office Nagole? Where do you stay in Hyderabad? Work Location: In person
Hi Everyone, We are looking the below requirement Position: Junior Accountant Location: Nagole_Hyderabad Skills: Tally, TDS, GST, Tax Filing and Entries Experience: 6 months to 2 years Interested candidates send your resume to sravanthi.b@thehirewings.com/8074940756 Job Types: Full-time, Permanent Pay: ₹12,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Fixed shift Morning shift Application Question(s): Where do you stay in Hyderabad? Experience: Accounting: 1 year (Required) Location: Nagole, Hyderabad, Telangana (Required) Work Location: In person
Hi Everyone, We are looking the below requirement Position: Junior Accountant Location: Nagole_Hyderabad Skills: Tally, TDS, GST, Tax Filing and Entries Experience: 6 months to 2 years Interested candidates send your resume to sravanthi.b@thehirewings.com/8074940756 Job Types: Full-time, Permanent Pay: ₹12,000.00 - ₹20,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Fixed shift Morning shift Application Question(s): Where do you stay in Hyderabad? Experience: Accounting: 1 year (Required) Location: Nagole, Hyderabad, Telangana (Required) Work Location: In person