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.
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.
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.
NTT Data Corporation