SQL Server Analyst

NTT Data Corporation Irving , TX 75061

Posted 2 months ago

Req ID: 36653

At NTT DATA Services, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company's growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA Services and for the people who work here.

NTT DATA Services currently seeks a SQL Server Analyst to join our team in Irving, Texas (US-TX), United States (US).

NTT DATA is currently looking for a SQL Server Analyst. Below are the job responsibilities:

  • Ability to grasp the application architecture, understand various workflows and related processes, etc.

  • Providing Audit deliverables for all Internal/External Audits

  • Setting up databases and related processes for Non-ESM products; troubleshooting issues related to Non-ESM file processing.

  • Analytical ability to understand business trends from various reports.

  • UAT data setup for testing any bug-fixes, application release

  • Co-ordination with DBA's and/or CATE DEV team for database/application performance issues.

  • Troubleshooting any data mismatch/data integrity issues

  • Coordination with DBA's and CATE Dev team for deployment to UAT and Prod

  • Designing and publishing key reports based on the business requirements.

  • Oversee L2 ADS support and performance tuning

  • Dbase tuning, advanced queue mgmt, migration of DTS packages to SSIS, extensive report automation.

  • Understanding on running and deploying the packages and scheduling jobs

  • Ability to monitor the Database and work with the DBA team if there is an issue.

data organizing and partitioning.

  • Provide database expertise to the software development team in the design, development and maintenance of the core database and application dataflow.

  • Plan, coordinate, and administer database systems, including based definition, structure, and documentation.

  • Some System Administration with datafile organization and VxVM experience.

  • Ability to plan, implement, and maintain backup and restore operations, database mirroring.

Required Skills:

  • 8+ years' experience working on Database Technologies SQL 2005, 2008R2, and 2012.

  • Experience writing custom/complex queries for reporting perspective

  • Experience with ODBC, JDBC and TCP

  • Experience with Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and VB scripting.

  • Experience with design and deploy SSIS packages for data load, reports, etc.

Desired Skills:

  • Mongo DB and/or Splunk experience a plus

  • Advanced knowledge of Compliance, Data integrity and Security.

  • Performance tuning using various SQL Server tools and application migration

  • ITIL and/or LEAN process and best practices

  • Excellent written, verbal and inter-personal skills.

This position is only available to those interested in direct staff employment opportunities with NTT DATA, Inc. or its subsidiaries. Please note, 1099 or corp-2-corp contractors or the equivalent will NOT be considered. We offer a full comprehensive benefits package that starts from your first day of employment.

About NTT DATA Services

NTT DATA Services partners with clients to navigate and simplify the modern complexities of business and technology, delivering the insights, solutions and outcomes that matter most. We deliver tangible business results by combining deep industry expertise with applied innovations in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services.

NTT DATA Services, headquartered in Plano, Texas, is a division of NTT DATA Corporation, a top 10 global business and IT services provider with 118,000+ professionals in more than 50 countries, and NTT Group, a partner to 88 percent of the Fortune 100. Visit nttdataservices.com to learn more.

NTT DATA, Inc. (the "Company") is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.


upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
VP Senior Instant Messaging Admin Lync/Skype SQL Server Vice President

Citigroup Inc.

Posted 2 months ago

VIEW JOBS 11/30/2018 12:00:00 AM 2019-02-28T00:00 * Primary Location: United States,Texas,Irving * Education: Bachelor's Degree * Job Function: Technology * Schedule: Full-time * Shift: Day Job * Employee Status: Regular * Travel Time: No * Job ID: 18042035 Description * Are you an experienced, highly motivated professional seeking a challenging and fulfilling position in a forward thinking company? * Do you enjoy taking on projects using cutting edge technology while working in a dynamic and fast paced environment? * Do you possess the ability to multi-task and work in a diverse and highly collaborative atmosphere? * If you answered yes to these questions, then you are exactly what we need and this will be an excellent opportunity for you so please keep reading… As a member of our Leading global team of Instant Messaging administrators you will be responsible for providing day-to-day support for critical issues and help ensure the highest level of availability and performance of all our systems from low priority to high demand. You will also be a key contributor to the design, installation, deployment and configurations of our production environment. You will have opportunity to use and develop your skills in Instant Messaging infrastructure support, Project Management, Infrastructure Planning, Incident and Problem Management, Change Control, Capacity Management, Patch Management, Vulnerability and Threat Assessment, Scripting and Automation and Cyber Security. The position is within the North America CTI (Citi Technology Infrastructure) EUS (End User Services) Organization reporting directly to EUS L3 Instant Messaging manager. You will be part of a dynamic team focusing on ways to improve and maintain service availability, improve end user experiences and deploy and migrate new technologies. You will work closely with all regional and global technology areas including Infrastructure, Application Development, Production Support, Operations and 3rd party vendors in order to enhance the quality, improve processes and propagate understanding of good practices across all services under your care. KEY RESPONSIBILITIES: * Consultative IT Support * Monitor and maintain Instant Messaging infrastructure * Analyze, evaluate, collaborate and provide recommendations for system enhancements, optimizations and development * Perform reviews and root cause analysis of production outages * Explore and discover opportunities to automate key tasks to drive improvement in productivity and efficiency * Create metrics and review operational Key Performance indicators to ensure effectiveness and efficiency and makes recommendations for improvement * Identify and call out risks and issues to the management. * Ensures the highest quality of work, and act a role model for other team members as well as cooperating with partners. * Effectively communicates with team members, peers and Senior Management, influences others through diplomacy and negotiation skills * Act as an advisory role and be a main point of contact for L2 critical issues. * Provide on-call support on nights and weekends on a rotating basis * Handle ServiceNow queues, incidents and task assignments * Liaise with Product Engineering to implement new standards and improve stability * Evaluate and improve operational procedure for increased efficiency in order to address potential gaps Development Value: * We have created an environment that will enable you to further develop yourself, by: * Constant upgrading of skills and computer related knowledge, enabling you to increase your Knowledge and develop Transferrable Skills. * Improving communication and project management skills * Achieve deep understanding of the Business and Technology Infrastructure organization * Increasing exposure to senior management * Directly influencing changes on a global level * Be a valued member of a dynamic and passionate Global Team. Qualifications * Bachelor's degree or higher, or equivalent combination of education/experience * Experience in an enterprise IT environment and related technology application in a complex global organization * A minimum of 5 years of enterprise Instant Messaging infrastructure administrative experience * Lync 2010/2013/2016/Skype Online – Experience installing, patching, troubleshooting of the product as well as an in-depth understanding of underlying technologies such as Windows Server, SQL, Active Directory, SIP routing, Click to Call (Cisco & Avaya), performance tuning, and health checks * Good understanding of Actiance Vantage compliance software * Strong Scripting Skills – PowerShell, VBScript, Lync Management shell This role is located in Irving TX. Apply Now Citigroup Inc. Irving TX

SQL Server Analyst

NTT Data Corporation