Description
SQLServer Database + Oracle database + Cassandra skill set.*
Sr. SQLServer Database engineering with hands on experience on cloud platform - "Amazon webServices" & NoSQL "Cassandra database".
Experience on Window and UNIX with minimum 8-10 years working experience in all areas of database Administration: performance tuning, data-pump, backup/recovery, KSH programming, PLSQL, init parameters, replication methods.
Expertise in Oracle 12c RAC, Performance tuning/troubleshooting skills and experience with VLDB's.
Technology.*
- Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Strong experience in Windows Failover clusters and Database Administration in SQL Server ( 2008,2012,2014).
- Experience in Installing and configuring new SQL Servers.
- Experience in working with Windows Servers, including Active Directory.
- Experience with backups, restores and recovery models in SQLServer
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience in Configuring SQL Server monitoring utilities(Idera, etc).
- Deploy database change scripts provided by third party vendors.
- Knowledge in Analysis Services, Integration Services, or Reporting Services
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues etc.
- Knowledge of SQL Server tools ( Profiler, SSMS, PerfMon, DMVs, system sprocs,etc)
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
- MCTS, MCITP, and/or MVP certifications a plus
- Oracle RAC/ASM. Amazon AWS, Cassandra dB, Data-replication tools - Shareplex & Golden-Gate
- Cloud foundry, Wide experience in infrastructure layout, provisioning. Extensive experience in Amazon AWS cloud infrastructure with particular reference to provisioning, security, and management. Design AWS infrastructure to move local applications to public & private cloud. Design complex solutions which integrate AWS cloud, on premise physical and Virtual server, EC2, S3 storage, networking and security. Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions
- Develop standardized AMI images and Cloud formation automation scripts for building non-prod and prod environments on AWS
- Design, deploy and support highly available and scalable distributed Cassandra (Datastax OR Apache) database solutions for high transactions mission critical applications.
- Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation
- Installations, configurations and monitoring DataStax Enterprise cluster and/or open source cassandra cluster
- Maintain and develop data models, structures, and procedures to ensure the integrity and performance of database components
- Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure
- Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities
- Research and evaluate alternatives and recommend solutions for business issues
- Create ad-hoc reports utilizing various data sources
- Maintain current knowledge of relevant technologies
- Participates in continuous improvement efforts in enhancing performance and providing increased functionality
- 24*7 on-call operations for mission critical application.
Bachelors Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, or work experience
*Not accepting 3rd party candidates at this time.