We provide IT Staff Augmentation Services!

Senior Computer Systems Analyst Resume

5.00/5 (Submit Your Rating)

Raleigh, NC

SUMMARY

  • Implement and deliver enterprise level projects throughout 20 - year IT experience
  • Diverse experience in Digital/big data Transformation | Data Integration | NoSQL/document database platform | DevOps | Automation | Analytics | Microservices | NoSQL Cloud solutions
  • Extensive experience in RDBMS, NoSQL, Storage, UNIX, Linux, Container, IT industry best practices
  • Presentation and demo
  • Constructing and staging cutting-edge POC (database, storage, infrastructure, DevOps automation)
  • Enterprise architecture (Business | Data | Technology) and deployment prototypes
  • Pictorial illustrations and process flow charts
  • Data Modeling | Governance, NoSQL | document database design, Data Integration | Transformation | Enrichment
  • Implement enterprise MarkLogic | NoSQL platform and automate such processes with API: clustering, App/database servers, replication, failover, tiered storage, backup, restore and/or transaction rollback
  • Deploy comprehensive security model including granular level data obfuscation or concealment; redaction (random and deterministic data masking and concealment; pattern-based redaction); 360° platform encryption (data, configuration files, log/auditing files encryption)
  • Design and deploy scalable infrastructure to meet transactional, search, high-performance, data model and service requirements
  • Design and deploy Operational Data Hub and security models
  • Design and implement canonical, provenance and lineage envelope pattern
  • Integrate, transform, harmonise and denormalise data
  • Search, research and serve harmonised data
  • Build client applications with Server-Side JavaScript API, REST API, Java API

TECHNICAL SKILLS

Database Platform: MarkLogic, AWS DB, MongoDB, Oracle

NoSQL | Cloud | Programming: REST API, Server-Side JavaScript, XQuery, Gradle, Maven, Java API, MarkLogic Data Hub, MarkLogic Java Client API, Optic API, JSON, XML, Shell Scripting, Kafka-MarkLogic-Connector, Apache NiFi

Oracle: RAC, Data Guard, Oracle Streams, DBArtisan, Grid/Cloud control, RMAN, Data Pump, Shell Scripting

Industry Skills: Data Migration, Integration, Data Modeling, Automation, DevOps, UNIX, Linux, Docker, VMWare, GIT Project Implementation, Service Delivery, Presentation, Demo, POC

Soft Skills: Enthusiastic, confident, adaptable, creative, accountable, client-focused, self-motivated

PROFESSIONAL EXPERIENCE

Senior Computer Systems Analyst

Confidential, Raleigh, NC

Responsibilities:

  • Collaborate with DBAs and clients to identify MarkLogic and Cloud-based NoSQL features and functionalities; design automation strategies and solutions; discover NoSQL in competitive Cloud landscape
  • Assist DBA and clients troubleshoot MarkLogic production issues
  • Design MarkLogic architecture, ER for Cloud automation and inventory management
  • Collaborate with vendor to execute DevOps NoSQL automation and integration in On-prem | public Cloud

Senior Computer Systems Analyst

Confidential

Responsibilities:

  • Lead and support multiple major database systems across America, APAC, EMEA regions. Major projects are Contract Data Utility/Legal Clause Analysis, Global Real Time Settlement
  • Collaborate with clients, SI and offshore resources to achieve significant project deliverables, reduce incidents, optimize automation adoptions, promote EOL Oracle system upgrade
  • Proactively identify opportunities, conduct review with clients, implement new processes to maintain system stability and enhance system performance
  • Troubleshoot and resolve databases related issues in various DB versions and complex environments (Oracle Streams, Oracle HA, JAP, SSL)
  • Actively promote and integrate Cloud and API automation technology initiatives
  • Expand NoSQL skillsets

Senior Computer Systems Analyst

Confidential

Responsibilities:

  • Lead and build database infrastructure for Credit-Suisse largest IT program: Legal Entity Project (Project involves Confidential 100+ critical financial systems)
  • Support Project Clifton and migrate Oracle 500+ DB servers throughout North America investment banking (equities, fixed income and infrastructure IT) and private banking applications
  • Troubleshoot and resolve database, RAC/ASM, Streams, DataGuard, DB upgrade issues in various Oracle versions and cross-platform Apps: reconfigure clusterware/network information/SCAN IPs/VIPs, post-migration DB performance issue, RAC server crash, ASM corruption and storage issue, Streams buildout process/performance issue/rebuild, DataGuard rebuild
  • Communicate with client to architect project infrastructure and achieve major product implementation objectives
  • Identify, construct and implement reusable migration process with SA and storage team

Senior Database Administrator

Confidential

Responsibilities:

  • First line production support (Oracle 7 to 11gR2; Database size 10TB+ ; Prod instances 200+, non-Prod instances 600+) for global investment banking business (Toronto, New York, London, Singapore, Brazil). 24 *7 on-call rotation. Applications include Wealth Management, Equity, Wall Street, Energy, Global Whole Sales, Fixed Income and Infrastructure.
  • Troubleshoot and resolve critical production problems (bug fix, performance issue, server/node hang/crash, disaster restore/recovery)
  • Lead, initiate and coordinate multiple key projects for the global corporate, investment banking and capital market business. Principal support for critical systems as SUMMIT, XEYE, Mobile Advisor and CRM
  • Design, implement and maintain VLDB systems across DEV, testing, UAT and Prod cycles
  • Implement HA solutions: Oracle RMAN, Standby, Data Guard, RAC, Steams replications, Grid control, ASM, Data warehouse

Senior Computer Systems Analyst

Confidential

Responsibilities:

  • Provide full aspects of Oracle support ( HP-UX/ Solaris/Linux/WIN; Oracle 8i to 11gR1; Database size 8TB+ ). 24 *7 on-call rotation
  • Initiate and implement RMAN/UNIX Shell backup, recovery and cloning solutions
  • Configure and manage HA RAC/cluster solutions for various applications
  • Design and implement Oracle Stream Replication. Resolve complex Stream error/hang/abort issues. Shell-scripting to monitor Stream capture/propagation/apply process. Streams cloning
  • Lead Oracle Grid Control project: Install, configure, patch and upgrade Grid console, OMS, Agents and repository database. Massive deploy and configure Grid Agents. Troubleshoot all levels of Grid issues
  • Proactively perform query/database tuning, OS Stats and Kernel parameter tuning; Resolve database error/crash issue
  • Support large Data Warehouse environment, troubleshoot ETL loading hang/locking/transient problem, performance tuning, query optimization, application server related issue
  • Lead multiple RDBMS, Data Warehouse, RAC upgrades. Proactively assess/apply latest patches/bug fix. Evaluate new products and up to date with new industry trends and initiatives
  • Participate and follow-up mission critical system disaster recovery in the BCP/DR plans
  • Secondary MySQL support

Database Administrator

Confidential

Responsibilities:

  • First line Oracle support ( HP-UX/Solaris/WIN/AIX; Oracle 8 to 10gR2; Database size 6TB +) for North America energy/utility service (Toronto, Calgary, Southern & Eastern US). Prod instances 30+, non-Production instances 100+, Production DR instances 10+. 24 *7 on-call rotation
  • Implement SQLBacktrack, Shell scripting, and RMAN backup and recovery solutions into multiple database versions and platforms
  • Lead Oracle BCP DR projects for Upstream and EMG applications. Configure and maintain multiple high-availability systems: physical standby, Data Guard and RAC. Develop standby monitoring process
  • Principal support for energy management trading systems; natural gas, electricity and major utilities billing systems
  • Lead support for DataWarehouse projects including scripting for partition maintenance, table and index maintenance for ETL
  • Perform system performance tuning for large DWS and billing systems
  • Provide professional support and maintenance for all phases of various major projects. Leverage resource and knowledge with software vendors to resolve database related issues
  • M aintain SQL Server Reporting Services, DTS, LiteSpeed backup service, log shipping and other database maintenance. Total SQLServer is 95+
  • Maintain Sybase ASE 12.5 server

Database Administrator and System Administrator

Confidential

Responsibilities:

  • initiated and executed multiple ASE 11.5 migrations to Oracle 8i commensurate with China Telecom’s strategic database platform and trajectory developed back-office Oracle client applications using PowerBuilder and PowerDesigner designed, constructed and staged Oracle + Sun + RedHat storage system POC (Proof of Competitiveness); Storage vendor: IBM “Shark” ESS/EMC, Sun, Dell, NetApp

We'd love your feedback!