Database Administration Specialist
NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Database Administration Specialist to join our team in Lincoln, Nebraska (US-NE), United States (US). Day to Day job Duties:
(what this person will do on a daily/weekly basis) Support databases in various environments. Install, configure, plan, and maintain systems. Install Oracle software and configure for databases and provide resolutions for databases. Coordinate changes to databases and troubleshoot 10g/11/RAC NODE/ instance eviction issues and document best practices. Troubleshoot RAC CRS auto start configuration issues and issues related to RAC Database Listener and VIP crashes. Plan, coordinate, and implement disaster recovery plan and security measures. Install and troubleshoot Oracle applications R11i/R12 performance issues and apply patches or family packs as needed. Collaborate with internal teams and interact with customers to find solutions for projects and operational issues for existing and proposed Systems Responsible for database design, troubleshooting, and planning. Responsible for data modeling and coordination for application migrations and updates with the application teams. Monitor database size and disk space in Production, UAT and Development environments. Handle more than 300 instances in the environment with database size of greater than 2 TB. Perform installations of SQL Server 2008?8R2 and SQL Server 2012 on Windows Servers. Configure Database Mail in SQL Server 2008?2?4 for proactive monitoring. Work and troubleshoot failover cluster issues and provide the root cause by coordinating with other teams. Set up SQL Server configuration settings for better server management. Troubleshoot the daily tasks such as backup failures and scheduled job failures for maintaining successful database backups and resolving the disk issues in the servers. Perform database migration from SQL 2005 to SQL 2008/2008R2 with application downtime sent across to all the teams and clients. Perform SQL Server upgrades and cumulative patches to all the servers for better performance and optimization. Perform the Database Archive activity using the IDERA SQL Compliance Manager tool. Responsible for user creation and provide necessary roles and privileges to the databases as per the requirements. Refresh the databases across all the environments using the backup and restore techniques. Create and schedule maintenance plans (Database Full and Log Backups, Cleanups). Monitor and administer the SQL Servers by Quest Spotlight Monitoring too. Review the Database Scripts from the application teams before deploying them in the production environment. Analyze the database health and growth reports on a monthly basis for proper capacity planning. Execute the Change Management scripts on a weekly basis Basic
Qualifications:
(what are the skills required to this job with minimum years of experience on each) Minimum 5
years of experience across the entire MS-SQL DBA operations Minimum 3
years of experience in fine-tuning the database operations /JOBS and SSRS reports Minimum 2
years of experience production support, resolving incidents, problem records and also supporting business teams in generating various reports Travel:
No travel required and 100% remote Degree:
Bachelors in Computer Science or equivalent work experience Nice to Have; (But not a must) Project lead experience #INDFSINS #L1-NAM About NTT DATA Services NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.
Salary Range:
$80K -- $100K
Minimum Qualification
Database AdministrationEstimated Salary: $20 to $28 per hour based on qualifications.
(what this person will do on a daily/weekly basis) Support databases in various environments. Install, configure, plan, and maintain systems. Install Oracle software and configure for databases and provide resolutions for databases. Coordinate changes to databases and troubleshoot 10g/11/RAC NODE/ instance eviction issues and document best practices. Troubleshoot RAC CRS auto start configuration issues and issues related to RAC Database Listener and VIP crashes. Plan, coordinate, and implement disaster recovery plan and security measures. Install and troubleshoot Oracle applications R11i/R12 performance issues and apply patches or family packs as needed. Collaborate with internal teams and interact with customers to find solutions for projects and operational issues for existing and proposed Systems Responsible for database design, troubleshooting, and planning. Responsible for data modeling and coordination for application migrations and updates with the application teams. Monitor database size and disk space in Production, UAT and Development environments. Handle more than 300 instances in the environment with database size of greater than 2 TB. Perform installations of SQL Server 2008?8R2 and SQL Server 2012 on Windows Servers. Configure Database Mail in SQL Server 2008?2?4 for proactive monitoring. Work and troubleshoot failover cluster issues and provide the root cause by coordinating with other teams. Set up SQL Server configuration settings for better server management. Troubleshoot the daily tasks such as backup failures and scheduled job failures for maintaining successful database backups and resolving the disk issues in the servers. Perform database migration from SQL 2005 to SQL 2008/2008R2 with application downtime sent across to all the teams and clients. Perform SQL Server upgrades and cumulative patches to all the servers for better performance and optimization. Perform the Database Archive activity using the IDERA SQL Compliance Manager tool. Responsible for user creation and provide necessary roles and privileges to the databases as per the requirements. Refresh the databases across all the environments using the backup and restore techniques. Create and schedule maintenance plans (Database Full and Log Backups, Cleanups). Monitor and administer the SQL Servers by Quest Spotlight Monitoring too. Review the Database Scripts from the application teams before deploying them in the production environment. Analyze the database health and growth reports on a monthly basis for proper capacity planning. Execute the Change Management scripts on a weekly basis Basic
Qualifications:
(what are the skills required to this job with minimum years of experience on each) Minimum 5
years of experience across the entire MS-SQL DBA operations Minimum 3
years of experience in fine-tuning the database operations /JOBS and SSRS reports Minimum 2
years of experience production support, resolving incidents, problem records and also supporting business teams in generating various reports Travel:
No travel required and 100% remote Degree:
Bachelors in Computer Science or equivalent work experience Nice to Have; (But not a must) Project lead experience #INDFSINS #L1-NAM About NTT DATA Services NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.
Salary Range:
$80K -- $100K
Minimum Qualification
Database AdministrationEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
