IGT Solutions
Location
Gurgaon | India
Job description
We are looking for Operational Specialist- SQL DBA || Immediate Joiner Remote work- 5 Working Days Duration: Permanent-Fulltime.
Primary Skills : DBA along with admin and maintain Data Warehouse (MS SQL, Oracle, MySQL) , ETL, SSIS, SSAS, DevOps, Agile. Qualification, Knowledge & Experience:- Bachelor's degree in Computer Science, Software Engineering, or a related field. Proven experience in an established DevOps and Agile Operations environment. Proven experience within an enterprise operations team Excellent problem-solving and analytical skills Highly competent at working at senior levels within an IT services provider or in the IT division of a large international matrix organization, working with (internal) customers at multiple levels. Must be able to demonstrate strong experience in acting in high-performing and self-managing teams of professionals, to deliver high value in terms of efficiencies and quality services. Familiarity and comfort with tools used in a continuous integration and continuous deployment pipeline is critical, as well as all the Toolset implemented and use by the relevant support teams. Experience problem solving issues on globally distributed systems and critical product service environments. Strong communication and collaboration abilities. Key Responsibilities and skills Work on DBA along with admin and maintain Data Warehouse (MS SQL, Oracle, MySQL). Have knowledge of Architecture like Federated Spoke and Hub, Kimball Dimensional Data Mars, Inmon Corporate Information Factory, Cloud integration and Azure replication / scripting. SQL fine tuning like Dead locks, indexing, SQL profiler, SQL job scripting, Indexing, Triggers Work on BI services including ETL (SSIS service). Connect and extract data from different Data sources. Transform Data and Content. Manage landing zones and Data cleansing. Master Data Management. Business entity integrity. Build Analytical Data Models (SSAS service), SSAS cubes (tabular/multi-dimensional). Abstract Data Warehouse table, simplify analysis for users. Pre-aggregate measures and provide standard interface, data consumed by client applications (Excel, Power BI, Reports) Reporting - Managing BIOPS report server (SSRS/Power BI). Build / design report data modes used by Self-service reporting. Interactive analysis, Dashboard and scorecards, Data mining. Manage IT-requested reports more than 500 + reports and1200 + subscriptions. Power BI integration. Infrastructure : Configure / admin Windows servers 2016 and up. Manage VMs (VMware ESXi).User account administration and Security policies, patches, SSL (Windows / SQL). Maintain Azure Data warehouse infrastructure (SQL DB, ETL, connectivity to Power BI). Automation: run VBScript, VB.net, C#, VBA, TSQL. Develop / Maintain / Troubleshoot more than 500 scripts. For SQL jobs, ETL transformations scrips. Report embedded codes, Power BI coding and Server automation. You can read more about us on our company career page or follow us on Linkedin to get the latest updates. For any query or clarification , you can connect me on email:[email protected] About IGT Solutions Pvt Ltd IGT Solutions (IGT) is a leading BPM, Technology and Digital Services and Solutions Company committed to deliver innovation and business excellence across the entire spectrum of Travel, Transportation and Hospitality domain. Established in 1998, with 100% focused on the Travel industry, we have more than 70 marquee customers globally. IGT serves 4 in top 5 Airlines, 4 out of Top 5 Travel Companies, 4 out of Top 5 Hospitality companies. We provide digital contact center services, travel technology and innovative digital services and solutions for 100+ travel processes including Reservations and Sales, Customer Service, IROPS Management, Baggage Helpdesk, Crew Helpdesk, Chatbots, Robotic Process Automation, Travel Analytics and Social Media Services. IGT employs more than 11‚000 travel experts globally with 100% focus on travel domain, providing services to Airlines, Travel Management Companies, Online Travel Agencies, Travel Technology Companies, Hotels, Railways, Airports, Cruises, Car Rental and Logistics. IGT is ISO 27001:2013, CMMI SVC Level 5 and ISAE-3402 compliant for IT, and COPC® Certified v6.0, ISO 27001:2013 and PCI DSS 3.2 certified for BPO processes. The organization follows Six Sigma rigor for process improvements. IGT Solutions provides equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these groups.Job tags
Salary
