2 Database Hardening Jobs

As a Database Security and Vulnerability Management professional, you will play a crucial role in ensuring the security of our esteemed client's databases. This immediate position based in Mumbai, BKC requires your expertise in Database Security Audit. Your primary responsibilities will include conducting security audits, vulnerability assessments, and ensuring database hardening to protect sensitive data. To excel in this role, you must possess a deep understanding of various database platforms such as Oracle, SQL Server, MySQL, PostgreSQL, and MongoDB. Proficiency in database architecture, schemas, and access controls is essential for implementing effective security measures. Your experience in security auditing and compliance standards like PCI-DSS, GDPR, HIPAA, and SOX will be valuable in assessing database security risks. You will be expected to apply hardening guidelines, manage user roles and permissions, and implement access control mechanisms to safeguard database resources. Proficiency in writing SQL queries and scripts for auditing purposes, along with the ability to identify vulnerabilities through SQL logs, is crucial for this position. In addition to vulnerability management and patching, you will be responsible for monitoring database events, implementing logging mechanisms, and ensuring backup and recovery processes are in place to secure critical data. Your knowledge of networking, firewalls, and incident response procedures will be instrumental in protecting databases from potential threats and responding to security incidents effectively. Strong communication skills are a must-have for this role, as you will be required to document findings, prepare reports, and communicate security recommendations to stakeholders. Your expertise in database security, vulnerability assessment, and a proactive approach to security measures will contribute significantly to our client's data protection efforts. If you are passionate about database security, possess the required skills, and are eager to make a positive impact in a dynamic work environment, we look forward to receiving your application for this Database Security Audit position.,

MongoDB Database Administrator 8 -10 years Experienced DBA (any database) MongoDB DBA (2 years plus) Scripting and programming experience Production deployment experience Migration experience from RDBMS to MongoDB. Exposure to public cloud would be an added advantage Responsibilities: MongoDB - CRUD Operations, Document based Data Modeling, Design of Collections and Documents Experience with physical collection creation, access pattern tuning, sharding implementation, index creation, and debugging query execution to obtain optimum database performance Excellent understanding of various MongoDB database design patterns and physical architectures for different use cases Data replication and sharding in a distributed database Aggregation of data using MapReduce and other batch processing use cases Experienced in MongoDB Security Detecting performance problems using Mongo Profiler Automate routine tasks with your own scripts and open-source tools Defragmentation Schema Design working with Application/Development team Query fine tuning Shell scripts for Monitoring like slow queries, replication lag, nodes fails, disk usage etc. Backup and restores ( Backups should be automated with shell scripts/Ops Manager) Database Health check (Complete review of Database slow queries, fragmentation, index usage...etc. ) Index rebuild Upgrades (Java version, Mongo version,etc) Maintenance ( Data center outages, etc) Architecture design as per the Application requirement Writing best practices documents for sharding, replication for Dev/App teams Log rotation/ maintenance ( mongos, mongod, config . etc) Segregation of duties ( User Management designing User roles and responsibilities ) Disk usage, CPU, Memory check Alerting Database Hardening Designing DR (Disaster Recovery)/COB ( Continuity of Business) plans as applicable Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Export and Import of Data to and From MongoDB, Run time configuration of MongoDB, Data Managements in MongoDB Capped Collections Expired data from TTL, Monitoring of Various issues related with Database, Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB, Database software Installation and Configuration in accordance with Client defined standards Database Migrations and Updates Application of database patches Capacity management Hands on experience in Server Performance tuning and Recommendations High availability solutions and recommendations Hands on experience in Root cause analysis for business impacting issues Do Provide adequate support in architecture planning, migration & installation for new projects in own tower (platform/dbase/ middleware/ backup) Lead the structural/ architectural design of a platform/ middleware/ database/ back up etc. according to various system requirements to ensure a highly scalable and extensible solution Conduct technology capacity planning by reviewing the current and future requirements Utilize and leverage the new features of all underlying technologies to ensure smooth functioning of the installed databases and applications/ platforms, as applicable Strategize & implement disaster recovery plans and create and implement backup and recovery plans Manage the day-to-day operations of the tower Manage day-to-day operations by troubleshooting any issues, conducting root cause analysis (RCA) and developing fixes to avoid similar issues. Plan for and manage upgradations, migration, maintenance, backup, installation and configuration functions for own tower Review the technical performance of own tower and deploy ways to improve efficiency, fine tune performance and reduce performance challenges Develop shift roster for the team to ensure no disruption in the tower Create and update SOPs, Data Responsibility Matrices, operations manuals, daily test plans, data architecture guidance etc. Provide weekly status reports to the client leadership team, internal stakeholders on database activities w.r.t. progress, updates, status, and next steps Leverage technology to develop Service Improvement Plan (SIP) through automation and other initiatives for higher efficiency and effectiveness Team Management Resourcing Forecast talent requirements as per the current and future business needs Hire adequate and right resources for the team Train direct reportees to make right recruitment and selection decisions Talent Management Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness Build an internal talent pool of HiPos and ensure their career progression within the organization Promote diversity in leadership positions Performance Management Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports. Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below Employee Satisfaction and Engagement Lead and drive engagement initiatives for the team Track team satisfaction scores and identify initiatives to build engagement within the team Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team Exercise employee recognition and appreciation Deliver No Performance ParameterMeasure 1Operations of the tower SLA adherence Knowledge management CSAT/ Customer Experience Identification of risk issues and mitigation plans Knowledge management 2New projectsTimely delivery Avoid unauthorised changes No formal escalations Mandatory Skills: MongoDB Admin.