Database Administrator

About Company: Finvasia is a multi-disciplinary, multinational organization that owns and operates over a dozen brands across financial services, technology, real estate & healthcare verticals. From the last 13 years of our history, Finvasia has managed funds for some of the notable hedge funds of The Wall Street, launched the first and only commission-free ecosystem for listed and Fee based financial products in India, provided technology to some of the notable listed and unlisted financial services entities across the globe, launched medically proven diabetes reversal program and engaged scientist from various specialized fields to build nano and micro medical devices that can monitor and assist in various body functions. From the last 13 years, we have catered to a few million clients in over 180 countries directly or via one of our subsidiaries. The notable brands owned by Finvasia are Fxview, Shoonya, Zulutrade, AAAfx, ACT Trader, CapitalWallet, Gini Health, bodyLoop, StackFlow, Finvasia estates, and portfolios.com Our team comprises over 350 employees that work in our offices across India, UK, Greece, Cyprus, Canada, Mauritius and USA. DATABASE ADMINISTRATOR We are seeking a highly skilled Database Administrator to join our growing team. The successful candidate will be responsible for the integrity, performance, and security of our databases. They will also be involved in the planning and development of the database as well as troubleshooting any issues on behalf of the users. Key Responsibilities: - Administer, maintain, develop, and implement policies and procedures for ensuring the security and integrity of the company database. - Monitor and optimize system performance using index tuning, disk optimization, and other methods. - Implement data models, database designs, data access, and table maintenance codes. - Resolve database performance and capacity issues, and replication and other distributed data issues. - Plan and coordinate data migrations between systems. - Develop, implement, and maintain change control and testing processes for modifications to databases. - Management and maintenance of backups and recovery procedures. - Install and test upgrades and patches. - Implement and maintain database security. - Develop database scripts for the purpose of automation. - Troubleshoot and correct database issues and ensure database recovery. - Design and implement disaster recovery plans. - Manage data warehousing plans and business intelligence initiatives. - Handle the deployment, maintenance, and support of current and future database systems in cloud environments. Requirements: - In-depth knowledge of specific DBMS such as Microsoft SQL Server, MySQL, PostgreSQL. - Proficiency in database design and modeling. - Expertise in SQL and query optimization. - Experience with backup and recovery strategies. - Proficiency in performance monitoring and tuning. - Understanding of high availability solutions and replication. - Expertise in database security and user management. - Experience in database migration and upgrades. - Proficiency in scripting languages like PowerShell, Python, or Bash. - Excellent problem-solving and troubleshooting abilities. - Understanding of disaster recovery planning and implementation. - Experience with data warehousing and business intelligence tools. - Familiarity with cloud-based database services such as Amazon RDS, Azure SQL Database, or Google Cloud SQL. Education and Experience: - Bachelor's degree in computer science or a related field. - At least 7-10 years of experience in database administration, information technology, database architecture, or a related field. - Immediate Joiner is preffered.