תומר לוינסקי

Backup & Restore: Full, incremental, and binary log backups; point-in-time recovery (PITR); replication-aware restores.

Database Design & Optimization: Schema design, indexing, foreign keys, constraints, normalization, query optimization, execution plan analysis.

Performance Tuning: Slow query analysis, profiling, query statistics, caching, partitioning, optimizer hints, temp tables, and handling large datasets.

High Availability & Replication: Master-slave, master-master replication, GTID-based replication, semi-synchronous replication, clustering (Galera), failover strategies.

Security: User management, roles, privileges, SSL/TLS connections, data masking, encryption (TDE/column-level).

Maintenance & Monitoring: Scheduled jobs/events, monitoring with performance_schema, logs (error log, general log, slow query log), purge history, stats collection, auto-increment and table maintenance.

T-SQL / Stored Code Equivalent: Stored procedures, triggers, functions, views, dynamic SQL, transactions, exception handling.

Files & Storage: Tablespaces, file-per-table, auto-growth, move/rename tables, backup & restore of InnoDB/MariaDB engines, compression.

Migration & Upgrades: Version upgrades, engine migration (MyISAM → InnoDB), replication setup, collation & charset management.

Experience (3+ Years)

PostgreSQL: 3 years of hands-on experience in database design, indexing, query tuning (EXPLAIN/ANALYZE), user/role management, backups & PITR, partitioning, replication, and extensions (PostGIS, FDW, pg_stat_statements).

Linux: Server administration, shell scripting, performance monitoring, and PostgreSQL deployment on Linux environments.

AWS: Deployed and configured RDS, EC2, Athena, ElastiCache, and Redshift.

Database Development: Designed and modeled databases using ERWIN; wrote PL/pgSQL functions, views, and triggers.

Data Engineering: Built and maintained ETL pipelines with Python, PySpark, and Pandas; automated workflows with Airflow and pg_cron.

Data Engineering: Built and maintained ETL pipelines with Python, PySpark,

Experience (3+ Years) – Microsoft SQL Server

Backup & Restore: Recovery models, full/differential/log backups, restores, and backup strategy planning.

Best Practices & Maintenance: TempDB optimization, instance & database-level configuration, jobs, alerts, DB Mail, Ola Hallengren scripts, indexing, statistics, purge history.

Monitoring & Performance: Profiler, trace, execution plan analysis, query statistics, isolation levels, NVARCHAR(MAX) handling, waits, locks & deadlocks, missing/unused indexes, fragmentation, page splits.

HADR & Replication: AlwaysOn Availability Groups, Log Shipping, Mirroring, Transactional Replication.

Security & Encryption: Logins, users, roles, TDE, AlwaysEncrypted, Column-Level Encryption, TLS, Data Masking.

Database Development & T-SQL: Temp tables, stored procedures, triggers, functions, RAISERROR, TRY/CATCH, dynamic SQL, archive data, synonyms, linked servers.

Files & Storage: Filegroups, autogrowth, move files, attach/detach, shrink files, compression, partitions.

Upgrades & Migrations: Database upgrades, version migrations, collation & compatibility handling, SQL hints, corruption handling.