Database Administrator - DB2
Design, develop, and maintain SQL Server and IBM DB2 databases, including tables, views, indexes, stored procedures, functions, triggers, and packages. Develop and optimize complex SQL queries and database scripts for performance, scalability, and reliability. Perform database performance tuning and troubleshooting, including query optimization, Explain Plan analysis, locking, deadlocks, and concurrency issues. Design database schemas, data models, and relationships based on business and application requirements. Develop and support ETL, data integration, migration, and data extraction processes across multiple data sources. Ensure data integrity, security, compliance, backup/recovery, and disaster recovery standards. Collaborate with application, analytics, and business teams to deliver effective database solutions. Support the complete database lifecycle, including design/code reviews, deployments, upgrades, releases, documentation, and database best practices.